Link to home
Start Free TrialLog in
Avatar of Cactus1993
Cactus1993Flag for United States of America

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:E1054,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!
Avatar of Shaun Kline
Shaun Kline
Flag of United States of America image

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=-
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.
ASKER CERTIFIED SOLUTION
Avatar of byundt
byundt
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Cactus1993

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."
Byundt: You nailed it. Thank you!