Hi, can I ask how to deal with the error values when the SUMPRODUCT() is to be used? I used a formula to sum up these cells as:
=SUMPRODUCT(--(MOD(COLUMN(A2:H2),2)=0),--(ISNUMBER(A2:H2)),A2:H2)
If A2:H2 contains error #N/A value, then the formual failed to work.
Just wondering how to make this work without array?
Bookmarks