Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT Formula??
I have 2 columns. Col. A is number values. Col. B is text Name data. What is the formula to count the number in Col. A IF the Col. B is equal to a specific text name data. life "Stefanie" A B 1 Danny 1 Stefanie 1 Danny 1 Danny 1 Danny -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=523251 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT Formula??
If you want to count you can use countif
=COUNTIF(B1:B5,"Stefanie") if you want to sum the numbers that have Stefanie in another column =SUMIF(B1:B5,"Stefanie",A1:A5) -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "dannyboy213" wrote in message ... I have 2 columns. Col. A is number values. Col. B is text Name data. What is the formula to count the number in Col. A IF the Col. B is equal to a specific text name data. life "Stefanie" A B 1 Danny 1 Stefanie 1 Danny 1 Danny 1 Danny -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=523251 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT Formula??
=countif(b2:b99,"stefanie")
(to just count the Stefanie's) or =sumif(b2:b99,"stefanie",a1:a99) to actually sum the values in column A. Debra Dalgleish has lots of notes for counting and summing at: http://contextures.com/xlFunctions04.html http://contextures.com/xlFunctions01.html dannyboy213 wrote: I have 2 columns. Col. A is number values. Col. B is text Name data. What is the formula to count the number in Col. A IF the Col. B is equal to a specific text name data. life "Stefanie" A B 1 Danny 1 Stefanie 1 Danny 1 Danny 1 Danny -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=523251 -- Dave Peterson |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT Formula??
Keep in mind that we we are counting the number values. The numbers can vary. -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=523251 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
COUNT Formula??
What does that mean? Do you mean that there are blanks in the number column
and they should not be counted? If so use =SUMPRODUCT(--(A1:A10<""),--(B1:B10="Stefanie")) Or do you mean unique numbers in the first column with a name criteria, also wouldn't it be reasonable that when you exemplify your problem that you actually use something that is closer to the data you are working with than to use 2 names and one number? Regardless =SUM(--(FREQUENCY(IF(B1:B10="Stefanie",MATCH(A1:A10,A1:A1 0,0)),ROW(INDIRECT("1:"&ROWS(A1:A10))))0)) array entered will count the unique numbers in the A where B is "Stefanie" -- Regards, Peo Sjoblom Northwest Excel Solutions www.nwexcelsolutions.com (remove ^^ from email address) Portland, Oregon "dannyboy213" wrote in message ... Keep in mind that we we are counting the number values. The numbers can vary. -- dannyboy213 ------------------------------------------------------------------------ dannyboy213's Profile: http://www.excelforum.com/member.php...o&userid=31032 View this thread: http://www.excelforum.com/showthread...hreadid=523251 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula for If Term is on Certain Date then Count | Excel Worksheet Functions | |||
More Help Needed with Count formula | Excel Worksheet Functions | |||
Count If formula | Excel Discussion (Misc queries) | |||
Count numbers formed from another formula | Excel Discussion (Misc queries) |