SUMIFS Issue

[Wet-Skunk]

I was hoping to get some help with a formula issue. This is my first time inquiring in a forum :D. On the attached why is the formula in T6 not returning the value of 1?

Andy

[jeffreybrown]

Try this instead >> =SUMIFS(I6:I11,E6:E11,"Evaluation Interview",L6:L11,"NJJC")

However, that's possibly just s band-aide. Your biggest problem is all those merged cells. You should try to eliminate merged cells if you can.

[Wet-Skunk]

Try this instead >> =SUMIFS(I6:I11,E6:E11,"Evaluation Interview",L6:L11,"NJJC")

However, that's possibly just s band-aide. Your biggest problem is all those merged cells. You should try to eliminate merged cells if you can.

That worked, thanks!!!

[Wet-Skunk]

=SUMIFS(I6:I11,E6:E11,"Evaluation Interview",L6:L11,"NJJC")

Taking this a step further. If I wanted the same formula to count "Evaluation Interview" for both R and B locations at the same time, how would it be modified? My end goal is for locations R&B with either Evaluation Interview, Evaluation Related or Testing Scoring to be counted. We are trying to count time spent with a range of activities at different locations. I want to avoid having to do a long formula as such (formula drawing from diffewrent sheet):

=SUMIFS(TEMPLATE!I6:I11,TEMPLATE!E6:E11,"Evaluation Interview",TEMPLATE!L6:L11,"R") + SUMIFS(TEMPLATE!I6:I11,TEMPLATE!E6:E11,"Evaluation Interview",TEMPLATE!L6:L11,"B") + SUMIFS(TEMPLATE!I6:I11,TEMPLATE!E6:E11,"Evaluation Related",TEMPLATE!L6:L11,"R") + SUMIFS(TEMPLATE!I6:I11,TEMPLATE!E6:E11,"Evaluation Related",TEMPLATE!L6:L11,"B") + SUMIFS(TEMPLATE!I6:I11,TEMPLATE!E6:E11,"Testing/Scoring",TEMPLATE!L6:L11,"R") + SUMIFS(TEMPLATE!I6:I11,TEMPLATE!E6:E11,"Testing/Scoring",TEMPLATE!L6:L11,"B")

[jeffreybrown]

Sorry, but this setup is not ideal for doing calculations because of all those merged cells.

Since your long formula works I would just go with it as it returns the answer you seek.

I will place a call to others to see if anybody has an idea.

[bebo021999]

Luckily that all data is linear, they are all in same row, so try using this:

Please Login or Register  to view this content.

[Wet-Skunk]

Thanks for the responses, I'm on track now!!

[jeffreybrown]

Glad you have a solution you can work with and you're welcome.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.