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:

1 Red Shoes

2 Pink Shoes

3 Red Shoes

4 Red Purse

5 Blue Purse

Count how many red shoes...

Thank you.

See More: Excel countif function

Report •

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 •

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 •

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

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 •

March 4, 2011 at 11:53:06
Try using =COUNTIFS() <- note the S at the end.

Look here:


  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")



Report •

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.


Report •

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;desks
Area 1 tables;chairs
Area 2 chairs;desks
Area 2 chairs
Area 3 desks
Area 3 tables
Area 4 tables;desks
Area 4 tables
Area 5 tables;chairs;desks
Area 5 chairs;desks

I 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 •

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:


Now when you enter your AREA in cell C1
and when you enter your ARTICLE in cell D1
Cell C2 shows you the total.



Report •

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 •

March 5, 2011 at 19:11:28
With the exact same set up, change the formula in Cell C2:




Report •

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

Report •

Ask Question