| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Embedding a Sumif in a sumif
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 |
|
#2
|
|||
|
|||
|
maybe..
=SUMPRODUCT(--(gift=1),--(perpay<0),children) "C.Pflugrath" wrote: 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 |
|
#3
|
|||
|
|||
|
=SUMPRODUCT(--(Gift=1),--(PerPay<0),Children)
-- Regards, Peo Sjoblom (No private emails please) "C.Pflugrath" wrote in message ... 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 |
|
#4
|
|||
|
|||
|
C,
=SUMPRODUCT((Gift=1)*(PerPay<0)*Children) HTH, Bernie MS Excel MVP "C.Pflugrath" wrote in message ... 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 |
|
#5
|
|||
|
|||
|
One way
=SUMPRODUCT(--(Gift=1),--(PerPay<0),Children) This assumes the ranges are of equal size. -- Regards Roger Govier "C.Pflugrath" wrote in message ... 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 |
|
#6
|
|||
|
|||
|
Fabolous! Thank You!
-- .. . . Cheers C.Pflugrath "Duke Carey" wrote: maybe.. =SUMPRODUCT(--(gift=1),--(perpay<0),children) "C.Pflugrath" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
| SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
| Dynamic sumif function | Excel Worksheet Functions | |||
| SUMIF Not | Excel Discussion (Misc queries) | |||
| SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions | |||
Linear Mode
