Hello all and thank you to anyone and everyone that can help me out.
I have a simple SUMIF formula, but the result seemingly returns the sum amount that includes a number that does not meet the criteria in the formula.
=SUMIF($A$1:$H$18,J20,$H$1:$H$18)
Cell J20 is "OT" but the formula seems to include the sum amount only for [H7(Reg):H8(OT)] yet excludes all others... I'm confused on the reasoning???
Thanks again for any help you can give me
The formula works correctly. There are hidden rows!
With
=SUMIF($A$1:$H$18,J20,$H$1:$H$18)
You are using 2 ranges different in size: one has 8 columns but other has 1 column only.
SUMIF works with single range (BOTH vertical OR horizontal range)
so, try:
=SUMIF($A$1:$A$18,J20,$H$1:$H$18)
Quang PT
Thank you checking it out,Originally Posted by phatdear
The original spreadsheet is a template that is going to include those currently for the time being; although, the hidden rows have no values within them which I assume should not make any difference.
I tried the formula and it resulted with the same amount
Did you see post #2? What result are you expecting?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
=SUMIF($A$1:$A$18,J19,$H$1:$H$18)
returns $1,676.80
Why do you expect a different answer, when that is the correct answer? You are either mistaken, or have failed to tell us something!!
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Just to point out to you again, this is from the the original file that you provided.
There are hidden rows (13-18) and there is value in one cell which is resulted from another formula.
js-MDNmg-Wg1.png
There is no value in the hidden rows that makes a difference - both Reg values are 0.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks