Counting Cells With Multiple Criteria on Multiple Sheets


Eric Meiers

I want to count---on multiple sheets---the number of times that a
given cell is greater than another cell if and only if a third cell
equal to a given value. I want to do this for 4 sets of data on each
sheet. I thought I had it figured out with this formula---


but it returns a value of zero each time. Clearly there is an error
in the formula.

Here is some background:
-- $H$1:$H$39 is a block of cells that has the names of the
sheets in the spreadsheet
-- E1 and F1, G1 and H1, I1 and J1, K1 and L1 are the four
of cells that I am comparing. In this case, I only want to count
1) when R1=2 and E1>F1 or when S1=2 and G1>H1 or when T1=2 and I1>J1
or when U1=2 and K1>L1.

Your help is greatly appreciated.


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question