Ignoring #NUM! in sum if, or getting rid of the error all togther

[MaximusW]

Hi,

I am trying to sum a colum of numbers based on data on another colum using the Sumif function. The numbers I am attmepting to sum are the result of a formula counting days between two dates. As not all of the date entries are complete (this is counting delivery dates and some items are not delivered) I have a few cells with #NUM! in them as there is no calculation. I am sure there is a simple way to add this into my formula but try as I might I cannot find it!!

Formula is as below, and I just need to know how to make that return no error.

=DATEDIF(H7,P7,"d")

Thanks in advance for anyone that can help.

Regards

Marcus

[JohnTopley]

Try


=IFERROR(DATEDIF(H7,P7,"d"),"") returns blank

or

=IFERROR(DATEDIF(H7,P7,"d"),0) returns 0


Or

=IF(OR(H7="",D7=""),"",DATEDIF(H7,P7,"d"))

[avk]

can you attach sample file.

[Phuocam]

Try this ...

=IF(COUNT(H7,P7)=2,P7-H7,"")

Or:

=IFERROR(P7-H7,"")

[MaximusW]

yep all good, Thanks all, saved me the afternoon buying new laptop after stamping on this one.!!