Hi,
I'm struggling with what I think is a pretty simple formula.
I have a table with data in it. Each row has information in some/all of the cells.
On a summary sheet I need to add up the number of rows on the table which meet a set of criteria across multiple columnes.
For example, Column A= Open, Column B= Approved, and Column C= Blank/deferred - this should = 1 on my summary sheet.
Another way to look at it may be, if Column A= Open, and anything in column B or C= Approved, then this should count as 1.
Any help would be much appreciated!
Thanks,
T
Bookmarks