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