Hello,
On this topic, I am trying to count the occurrence of two criteria within a given row.
For example: How many rows contain a cell with "rc2" and a cell with "out" within the same row?
I have fond examples of once criteria being a text value and then one being a number value greater than or less than.
What formula would I use for two or more text criteria?
Hello simmonsmtb31,
"Hijacking" old threads is against our forum rules......and you won't get many replies as you might have noticed (most contributors prefer to post to threads with few replies). For that reason I have split your question into its own thread......
You can count rows with 2 values like this
=SUMPRODUCT((A1:A100="x")*(B1:B100="y"))
Last edited by daddylonglegs; 08-05-2009 at 04:13 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks