Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Need a function
Hi All, I need a function or something that will make my file work. What I want to do is get all the one colum go down and check to see if there is a "W","P", or "C". And when it finds one there it will add to the my total count. For example: Column B 1 W 2 C 3 W 4 W 5 P 6 C 7 8 9 W 10 P Total W = 4 Total P = 2 Total C = 2 PS I'm sending a file along with this just to show +-------------------------------------------------------------------+ |Filename: Total Letters.zip | |Download: http://www.excelforum.com/attachment.php?postid=3543 | +-------------------------------------------------------------------+ -- jcc31 ------------------------------------------------------------------------ jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692 View this thread: http://www.excelforum.com/showthread...hreadid=382619 |
#2
|
|||
|
|||
If I understand correctly, youwant the COUNTIF function =COUNTIF(A1:A10,"W") adapt as necessary. Is that it? -- MrShorty ------------------------------------------------------------------------ MrShorty's Profile: http://www.excelforum.com/member.php...o&userid=22181 View this thread: http://www.excelforum.com/showthread...hreadid=382619 |
#3
|
|||
|
|||
PREFECT!!!!! I did know there was a function like that. Sorry, I new to excel -- jcc31 ------------------------------------------------------------------------ jcc31's Profile: http://www.excelforum.com/member.php...o&userid=24692 View this thread: http://www.excelforum.com/showthread...hreadid=382619 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
I NEED HELP with the SPELLNUMBER Function | Excel Worksheet Functions | |||
Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Date & Time | New Users to Excel | |||
Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
clock | Excel Worksheet Functions |