ExcelBanter - SUMPRODUCT

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

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

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

ColleenK

SUMPRODUCT

Hi There,

Can anyone tell me why I am getting #Value! error with the following formula;

=SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300))
--
CK

Sean Timmons

SUMPRODUCT

all ranges must be of the same size. Can't have:

$B$70:$B$3003

get rid of that second 3.
"ColleenK" wrote:

Hi There,

Can anyone tell me why I am getting #Value! error with the following formula;

=SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300))
--
CK

Sean Timmons

SUMPRODUCT

oh, and add another - to the second criterion.

"ColleenK" wrote:

Hi There,

Can anyone tell me why I am getting #Value! error with the following formula;

=SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300))
--
CK

ColleenK

SUMPRODUCT

Thank you so much, that fixed it!
--
CK

"Sean Timmons" wrote:

oh, and add another - to the second criterion.

"ColleenK" wrote:

Hi There,

Can anyone tell me why I am getting #Value! error with the following formula;

=SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300))
--
CK

Sean Timmons

SUMPRODUCT

You were most of the way there already. :-)

"ColleenK" wrote:

Thank you so much, that fixed it!
--
CK

"Sean Timmons" wrote:

oh, and add another - to the second criterion.

"ColleenK" wrote:

Hi There,

Can anyone tell me why I am getting #Value! error with the following formula;

=SUMPRODUCT(--(DATASHEET!$B$70:$B$300=C87),-(DATASHEET!$B$70:$B$3003<""),(DATASHEET!$E$70:$E$ 300))
--
CK

All times are GMT +1. The time now is 04:02 PM.