SUMIF problem

[JakeMann]

Hi All,

Can someone help with a sumif problem.

On the attached I have a sumif formula on page 'Machine 1' in column I9. For some reason it's returning a 0 and I have no idea way!

Any ideas...?

[daddylonglegs]

Hello Jake - the dates in column C also include times so you don't get an exact match with the date within the SUMIF formula. The easiest way to fix is probably to change the column C formula - additional INT function will extract just the date without the time, i.e. in C9 copied down use:

=IFERROR(INT(INDEX(Formula!H:H,MATCH(ROWS($A$9:$C9),Formula!$M:$M,0))),"")

now your SUMIF should work as required......

[Pepe Le Mokko]

Or

Please Login or Register  to view this content.

in I9

[JakeMann]

Brilliant! Thanks Daddylonglegs

[JakeMann]

Oh and thank you too Pepe

Another problem though.

The sum if appears to be working but I ahve an example where the formula is summing up against 4 different instances of a date eg.

25/02/2013 - 2
25/02/2013 - 2
25/02/2013 - 3
25/02/2013 - 2

obviously this should be returning 9 but is returning 0 and moving onto the next date.

Why would it not add up?