Hello,
I'm looking to do a SUMPRODUCT to add up numbers with multiple criteria. The issue I'm running into is that a #VALUE error occurs due to text being included within the data. I can not remove this text, as it's part of the original data set (e.g. Date ranges as headings within the data). So, how would I go about allowing the formula to ignore the #VALUE errors it's picking up within the array?
Simplified sample might look like this:
B1:H1: Weekly date range (1/7, 1/14, 1/21, etc.)
A2:A20: City Name
B2:B20: Tactic Name
C2:H20: Data (some numbers, some text)
=SUMPRODUCT((Data)*(Tactic="Tactic1")*(City="City1"))
My SUMPRODUCT needs to match the columns with a date and the rows with a city name and tactic name. The text is causing a #VALUE error.
Any help would be appreciated.
Thank you.
Bookmarks