ExcelBanter - #value error

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - #value error (https://www.excelbanter.com/excel-discussion-misc-queries/229177-value-error.html)

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?

Make sure that the ranges have the same number of cells in them.

G26:G59 is 34 cells
AW9:AW36 is 28 cells
AZ9:AZ36 is 28 cells

jake wrote:

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?

--

Dave Peterson