Please help someone. I have been trying to get a response on how to correct
this formula. I will always have some NA's in my columns that have the
criteria that I am summing on. I posted this question before but no one
seems to know the answer. Here is the formula that I have been working with:
=SUMPRODUCT(($L$7:$L$2585="F")*(I32:I2610=AP2627)* (AS32:AS2610)). I get a
result of NA but the formula shouldn't be looking at the NA's anyway. I
always thought that sumproduct ignored these but even if not, they are not
part of the criteria. Do I have this formula wrong. I am trying to sum
column AS if column L = "F" and column I equals whatever I have in cell AP267
(in the case an "11")