I'm not very proficient in Excel so here's my problem: A B

1 Red Shoes2 Pink Shoes

3 Red Shoes

4 Red Purse

5 Blue Purse

Count how many red shoes...Thank you.

RWCS

Your query should be posted here for more help: http://www.computing.net/forum/offi... This sounds like a homework question... is it?

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.

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.

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.

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 PurseUse the formula: =COUNTIFS(A1:A5,"red",B1:B5,"shoes")

MIKE

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

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;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.

=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;desksThen 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 D1

Cell C2 shows you the total.MIKE

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?

With the exact same set up, change the formula in Cell C2: =SUMPRODUCT(--(ISNUMBER(SEARCH(C1,A1:A10))),--(ISNUMBER(SEARCH(D1,B1:B10))))

MIKE

It works! Thank you, thank you, thank you!

Ask Your Question

Weekly Poll

Do you trust smart speakers to not spy on you?

Discuss in The Lounge

Poll History