# Excel countif function

March 3, 2011 at 10:06:53
Specs: Windows XP
 I'm not very proficient in Excel so here's my problem: A B 1 Red Shoes2 Pink Shoes3 Red Shoes4 Red Purse5 Blue PurseCount how many red shoes...Thank you.RWCS

See More: Excel countif function

#1
March 3, 2011 at 14:04:27
 Your query should be posted here for more help: http://www.computing.net/forum/offi...This sounds like a homework question... is it?

Report •

#2
March 4, 2011 at 06:53:30
 No. It's actually more complicated than this. Second column actually has different list of information that I need to filter through and count individually. I'm working on an extract from a database and info are grouped in one cell. Somehow, my formula is not working.

Report •

#3
March 4, 2011 at 09:57:58
 If its more complicated, don't dumb it down. Nothing is more frustrating than someone spending their time working on a code or solution to your problem, only to find out it doesn't work because you actually needed something slightly more complex.Trust me, it happens all the time. Just post your actual examples or what you actually need. If you don't like posting it publicly, some people are willing to communicate via PM and emails to help you.

Report •

Related Solutions

#4
March 4, 2011 at 10:35:20
 Sorry, I'm dealing with confidential info. It's for my work. I know how to count the words in a column where there are several other words in each cell using countif function and using asterisks to represent other words. I just need to figure out what formula to use if there is another column of criteria that I need to include. I just need a little guidance then I'll go from there. Thanks.

Report •

#5
March 4, 2011 at 11:53:06
 Try using =COUNTIFS() <- note the S at the end.Look here:http://office.microsoft.com/en-us/e...``` A B 1) Red Shoes 2) Pink Shoes 3) Red Shoes 4) Red Purse 5) Blue Purse ```Use the formula: =COUNTIFS(A1:A5,"red",B1:B5,"shoes")MIKEhttp://www.skeptic.com/

Report •

#6
March 4, 2011 at 12:08:12
 Thanks Mike. I didn't know you can do that. I'll fix my spreadsheet on Monday when I get back to work. I'll let you know.I really appreciate your help.Raquel

Report •

#7
March 5, 2011 at 11:01:03
 tried COUNTIFS, didn't work. Below is what my table really looks like. I used wildcard characters to represent other words when I'm counting a particular item.Area 1 tables;chairs;desksArea 1 tables;chairsArea 2 chairs;desksArea 2 chairsArea 3 desksArea 3 tablesArea 4 tables;desksArea 4 tablesArea 5 tables;chairs;desksArea 5 chairs;desksI can count a particular item for just one column using =COUNTIF(F2:F11,"*chairs*") but I couldn't figure out how to count just for Area 1.Thank you.

Report •

#8
March 5, 2011 at 12:25:06
 =COUNTIFS() is a new function in 2007, if your not using 2007, then we need to do this a different way.Try this:=IF(COUNTIFS(A1:A13,"Area 5",B1:B13,"*tables*")If your data looks like this:``` A B C D 1) Area 1 tables;chairs;desks Area 5 desks 2) Area 1 tables;chairs 2 <--Formula 3) Area 2 chairs;desks 4) Area 2 chairs 5) Area 3 desks 6) Area 3 tables 7) Area 4 tables;desks 8) Area 4 tables 9) Area 5 tables;chairs;desks 10) Area 5 chairs;desks ```Then in Cell C2 enter the formula:=IF(OR(ISBLANK(C1),ISBLANK(D1)),"",COUNTIFS(A1:A13,"*"&C1&"*",B1:B13,"*"&D1&"*"))Now when you enter your AREA in cell C1 and when you enter your ARTICLE in cell D1Cell C2 shows you the total.MIKE

Report •

#9
March 5, 2011 at 18:03:25
 Aaaaaargh! I have 2007 at home but we still use 2003 at work. We're a bit dated in the office. Thank you so much for your help. You wouldn't happen to know how to do the formula in Excel 2003 do you?

Report •

#10
March 5, 2011 at 19:11:28
 With the exact same set up, change the formula in Cell C2:=SUMPRODUCT(--(ISNUMBER(SEARCH(C1,A1:A10))),--(ISNUMBER(SEARCH(D1,B1:B10))))MIKE

Report •

#11
March 6, 2011 at 16:23:52
 It works! Thank you, thank you, thank you!

Report •