Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
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 | |
|
|
![]() |
||||
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 |