Thread
:
sumproduct if
View Single Post
#
8
b&s
Posts: n/a
.... or:
=SUMPRODUCT((A1:A11="BUY")*(B1:B11+C1:C11))
--
pozdrav!
Berislav
papou wrote:
=SUMPRODUCT((A1:A10="BUY")*(B1:B10))+SUMPRODUCT((A 1:A10="BUY")*(C1:C10))
HTH
Cordially
Pascal
"sumproduct if" <sumproduct
a écrit
dans le message de news:
...
can you give me an example? Say i have:
A B C
BUY 2 4
BUY 4 8
SELL 3 4
BUY 5 2
if i want to sumproduct columns B and C only where column A = "BUY",
what would be the formula?
"papou" wrote:
Hi
SUMPRODUCT will allow multi-criteria whereas SUMIF only allows one
criteria.
Now if I understand rightly, you have one criteria and several
columns to add.
In which case you may add several SUMPRODUCT together.
HTH
Cordially
Pascal
"sumproduct if" <sumproduct
a écrit
dans le message de news:
...
i need a "sumproductif" function:, a combination of sumif and
sumproduct
e.g. i need to sumproduct values in columns A and B if a condition
in column
C holds
does anyone know of anything that would do this??
Reply With Quote