Cactus1993
asked on
COUNTIF is apparently not quite the same formula format as SUMIF, correct? Need a little help correcting my formula.
I currently have the formula
=COUNTIFS($A$50:A1054,">=" &$I$24,$A$ 50:A1054," <="&$J$25, $E$50:E105 4,F35)
Instead of counting the occurances in this range, I want to sum them.
Simply swapping out COUNTIF for SUMIF doesn't quite work. What's the trick?
Thank you!
=COUNTIFS($A$50:A1054,">="
Instead of counting the occurances in this range, I want to sum them.
Simply swapping out COUNTIF for SUMIF doesn't quite work. What's the trick?
Thank you!
Your original formula used COUNTIFS. Try using SUMIFS.
Without having the data, Its more a guess than anything else, but it seems that your 4th criteria is written just as F35 when it should be "="&F35
Hope it help.
-=Yuval=-
Hope it help.
-=Yuval=-
The SUMIF and SUMIFS formulas need a column/range of data to sum, a column/range to compare, and a value/column/range to compare against. So they differ from the COUNTIF/COUNTIFS formulas in that they do not have the sum range.
Include a sum range and see if that works.
Include a sum range and see if that works.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Shaun: Replacing COUNTIFS with SUMIFS
... returns "Not enough arguments were entered for this function."
- - - - - - - - -
Yuval: Replacing F35 with "="&F35 returns the following for both SUMIF and SUMIFS:
=SUMIF($A$50:A1054,">="&$I $24,$A$50: A1054,"<=" &$J$25,$E$ 50:E1054," ="&F35)
... returns "Too many arguments were entered for this function."
=SUMIFS($A$50:A1054,">="&$ I$24,$A$50 :A1054,"<= "&$J$25,$E $50:E1054, "="&F35)
... returns "Not enough arguments were entered for this function."
... returns "Not enough arguments were entered for this function."
- - - - - - - - -
Yuval: Replacing F35 with "="&F35 returns the following for both SUMIF and SUMIFS:
=SUMIF($A$50:A1054,">="&$I
... returns "Too many arguments were entered for this function."
=SUMIFS($A$50:A1054,">="&$
... returns "Not enough arguments were entered for this function."
ASKER
Byundt: You nailed it. Thank you!