Excel 2007 : SUMIFS not working completely

**bjstaten** · 01-14-2012, 09:25 AM

I'm using the SUMIFS function to calculate Downtime by area, shift and month, and for some reason have gotten it to work for some of the data, but not all of it.
For example, I've gotten the function to work calculating the 2nd shift numbers, but it isn't calculating the 1st shift numbers. I've spent a couple of hours on this already, and am scratching my head as to what the hitch is!!

Any help would be greatly appreciated!!!

Thanks!

(P.s. the formulas are located in cells AG4:AH9)

**Bob Phillips** · 01-14-2012, 11:53 AM

All of the data for 1st shift contains a space after 1st, so you are comparing 1st against 1st[space].

**bjstaten** · 01-14-2012, 12:03 PM

Bob,

Turns out I was comparing two "unlike" cells, as a result of the space!! What's frustrating is I checked this probably 3 times, and it was fine. There must have been another problem, and while troubleshooting it, replaced the contents of the 'Shift' column, inadvertantly adding a space and not realizing it!!

I need to quit working so hard against myself!!!

Many thanks!!