Embedding a Sumif in a sumif

G

Guest

Attempted to embed a sumif into a sumif. Formula
=sumif(Gift,1,sumif(PerPay,"<>0",Children)) returns message "The formula you
types contains an error."

Need to sum the range "Children" based on criteria in both the "Gift" and
"PerPay" colums. Suggentions? Alternatives?

.. . . Cheers & Thank You
C.Pflugrath
 
P

Peo Sjoblom

=SUMPRODUCT(--(Gift=1),--(PerPay<>0),Children)

--
Regards,

Peo Sjoblom

(No private emails please)
 
R

Roger Govier

One way
=SUMPRODUCT(--(Gift=1),--(PerPay<>0),Children)
This assumes the ranges are of equal size.
 

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

Similar Threads

subtotal with sumif nested 1
Sumif Multiple Columns 2
SUMIF on a Calculated Field 3
SUMIF() to add cells in non-contiguous ranges? (Excel 2003) 4
Can I have two conditions in a SUMIF? 5
=sumif function 1
SUMIF formula using data from another file 2
sumif - with 2 conditions - rows and columns 2

Top