ExcelBanter - SUMPRODUCT Question

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

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

- - SUMPRODUCT Question (https://www.excelbanter.com/excel-discussion-misc-queries/170248-sumproduct-question.html)

Karen Smith

SUMPRODUCT Question

I'm trying to use this formula, but its not working, what am I doing wrong?

=SUMPRODUCT(--('The Worker Be!'!A3:A99=C9),--('The Worker
Be'!d3:d99)=E7),'The Worker Be'!aa3:aa99)

joel

SUMPRODUCT Question

Try debugging the formula usingg the following

Tools - formula auditing - evaluatte formula

Post where the problem is occuring.

"Karen Smith" wrote:

I'm trying to use this formula, but its not working, what am I doing wrong?

=SUMPRODUCT(--('The Worker Be!'!A3:A99=C9),--('The Worker
Be'!d3:d99)=E7),'The Worker Be'!aa3:aa99)

All times are GMT +1. The time now is 04:22 AM.