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
Bookmarks