Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
If two cells have specific text to count as 1
I want to count the number of times a row has two specific words, in two
different cells eg. If column A contains the word 'Widget' and column B contains the word 'Sale' I want to count the number of times this occurs. I'm sure this is easy but I've spent hours trying to get it to work. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't see text in cells | Excel Discussion (Misc queries) | |||
formula to count cells containing #'s in a specific range | Excel Worksheet Functions | |||
Count by Colour (Text) with other criteria | Excel Discussion (Misc queries) | |||
count cells that contain text entries | Excel Worksheet Functions | |||
How to count occcurence of specific text block in a column | Excel Discussion (Misc queries) |