Compound SUMIF

[mckenny]

I've got two columns but I only want to ge the grand total if the sum of column A is greater than 20 and if sum column C is greater than 25. What is the right formula?

The No Sum Section
A B
5 4
5 3
2 7
8 15

A B
4 5
3 2
18 17
12 11


Thanks for the help!

 

[Zack Barresse]

Hi there,


Without seeing anything else, maybe ...


=IF((SUM(A:A)>20)*(SUM(C:C)>25),SUM(A:A,C:C),0)

 

[nbrcrunch]

Enter the following in the cell C1 (assuming the first data row for columns A & B are 1)

=IF(AND(A1>20,B1>25),SUM(A1:B1),"")

---

Oppsss, your original post indicated columns A & C were the data columns, but in the same post, you used columns A & B as data columns. My assumption is that data is in columns A & B. Column C will show a sum ONLY if values in rows of column A > 20 AND values in rows of column B > 25. Unlike the other posters, I also assume that you are considering each record (row) individually and not as a whole dataset.

Also, your illustration didn't have ANY qualifying records.

 

[PA HS Teacher]

If I understand your question correctly:

To sum column A
=If(And(Sum(A1:A4>20,C1:C4>25),Sum(A1:A4))

To sum column C
=If(And(Sum(A1:A4>20,C1:C4>25),Sum(C1:C4))