Sum.If function but depending on 3 different columns?
You can not use the whole column in array formulas or formulas that work
like array formulas
also the ranges need to be of equal size
maybe something like
=SUMPRODUCT(--(WS1!A1:A65535=1);--(WS1!B1:B65535="b");--(WS1!C1:C65535<9);WS1!D1:D65535)
or
=SUMPRODUCT(--(WS1!A1:A14=1);--(WS1!B1:B14="b");--(WS1!C1:C14<9);WS1!D1:D14)
--
Regards,
Peo Sjoblom
"corne_mo" wrote in message
...
Still one questions though:
I tried this over multiple worksheets, where the table is on worksheet1
and
the formula in worksheet 2:
=SUMPRODUCT(--(WS1!A1:A14=1);--(WS1!B:B="b");--(WS!C:C<9);WS1!D1:D14)
The following statements give errors:
--(WS1!B:B="b")
--(WS!C:C<9)
What am I doing wrong here?
|