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!
Cactus1993OwnerAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Shaun KlineLead Software EngineerCommented:
Your original formula used COUNTIFS. Try using SUMIFS.
Yuval_ShohatComputer Co-ordinator Team LeaderCommented:
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=-
Shaun KlineLead Software EngineerCommented:
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.
Learn Ruby Fundamentals

This course will introduce you to Ruby, as well as teach you about classes, methods, variables, data structures, loops, enumerable methods, and finishing touches.

byundtMechanical EngineerCommented:
If you want to sum the values in column A that were counted by your COUNTIFS, you list them as the first parameter. The ranges and criteria from the COUNTIFS then follow as additional parameters.
=SUMIFS($A$50:A1054,$A$50:A1054,">="&$I$24,$A$50:A1054,"<="&$J$25,$E$50:E1054,F35)

Open in new window

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Cactus1993OwnerAuthor Commented:
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."
Cactus1993OwnerAuthor Commented:
Byundt: You nailed it. Thank you!
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Office Productivity

From novice to tech pro — start learning today.