J
jake
Please Help.
I've been using this formula
=SUMPRODUCT(--(G26:G59=AX9),--(AW9:AW36=AW44),AZ9:AZ36)*COUNTIF(G26:G59,AX9)
It keeps returning a #VALUE! error and I'm not sure why. I've used a similar
formula before (same syntax, different context) and it worked fine. This is
pretty much the same situation just different content and i keep getting this
error. Columns G, AX and AW all have text and column AZ is numerical. Could
that be the problem?
I've been using this formula
=SUMPRODUCT(--(G26:G59=AX9),--(AW9:AW36=AW44),AZ9:AZ36)*COUNTIF(G26:G59,AX9)
It keeps returning a #VALUE! error and I'm not sure why. I've used a similar
formula before (same syntax, different context) and it worked fine. This is
pretty much the same situation just different content and i keep getting this
error. Columns G, AX and AW all have text and column AZ is numerical. Could
that be the problem?