I know how to create sumproduct formulas that have conditions (see below). But is there a way to create a sumproduct formula that only sums values that aren't errors?
Here is my formula that accounts for 2 filters ("Americas" and D$6):
Formula:=SUMPRODUCT(--('5-8-13'!$E$2:$E$5000="Americas")*('5-8-13'!$H$2:$H$5000=Americas!D$6),'5-8-13'!$T$2:$T$5000)
My data includes "#DIV/0!" errors in column T:T and I want to avoid those rows. Please tell me if I need to clarify.
Thanks
Bookmarks