Hello:

The following formulas are kicking-out the #VALUE! error. It worked fine on the spreadsheet No. 1 but when I copied and pasted fomula to another spreadsheet with the exact same layout and formatting, I received this error. I thoroughly checked the formula to ensure I did not inadvertantly place a space, etc. but it seems to to be entact.

Is there another function that could be added to trap/catch data type or other errors that are irrelevent?

=SUMPRODUCT(($C$42:$C$61<>"Time:")*E42:E61) and

=SUMPRODUCT(($C$42:$C$61="Time:")*E42:E61)

Column C is text data and column E is the number data.

Thanks a bunch for your assistance.Test Events.xlsx