deadlyliquidx
New Member
- Joined
- Feb 6, 2015
- Messages
- 27
Basically I am working with a spreadsheet with alotta REF!, NA, Texts and blanks within the data array and I dont have the time to manually remove them,
how can I make this formula to ignore all those errors and blanks in the data array without having to manually change data to suit the formula.
=SUMPRODUCT(('2015OTB'!K16:N23)*('2015OTB'!A16:A23=A16)*(ISNUMBER(MATCH(K2:N2,A1:A2,0)))*(ISNUMBER(MATCH(K14:N14,A3:A4,0))))
thanks
how can I make this formula to ignore all those errors and blanks in the data array without having to manually change data to suit the formula.
=SUMPRODUCT(('2015OTB'!K16:N23)*('2015OTB'!A16:A23=A16)*(ISNUMBER(MATCH(K2:N2,A1:A2,0)))*(ISNUMBER(MATCH(K14:N14,A3:A4,0))))
thanks