INDEX/MATCH: how to prevent #N/A error

Hi Valued Forum Members,

I have a situation in which I want to SUM several costs in separate columns according to the date to which they correspond.

(see attached sheet with dummy example)

eg: any cost falling on April 3, sum them and give the total amount.

I can achieve this using iterations of the following formula:

Please Login or Register  to view this content.

My problem is that if the date range in columns L or O don't fall within the range in column F (which will always be FIXED), the formula returns #N/A.

Is there any way in which I can still add all the values, but override the error if the dates don't happen to (always) match?

Regards,

Z.

Hi Z,

Try this:

Please Login or Register  to view this content.

Cheers,