A
AZ
I have a source data in several colums and raws. I am trying to sum amounts
that satisfy several conditions.
that satisfy several conditions.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
A
Arjen
HI
I don't know withing SUMIF (or COUNTIF) how to approach it
you could consider creating an output row or column that solves the IF
CLAUSE or condition wiht a 1 for true and 0 for false. In that same formula
or another resulting column / row you could multiply to target cell value
with that 0 or 1. You now SUM the result row/column you just created
This would give you the output
You could hide the in between columns/rows if need be
;-)
Arjen
I don't know withing SUMIF (or COUNTIF) how to approach it
you could consider creating an output row or column that solves the IF
CLAUSE or condition wiht a 1 for true and 0 for false. In that same formula
or another resulting column / row you could multiply to target cell value
with that 0 or 1. You now SUM the result row/column you just created
This would give you the output
You could hide the in between columns/rows if need be
;-)
Arjen
T
Toppers
Look at SUMPRODUCT which allows summation of multiple conditions across a
(any) number of columns. Perhaps an example of what you want would enable a
fuller reply.
(any) number of columns. Perhaps an example of what you want would enable a
fuller reply.
G
George Tattam
I think array formula's are the solution here.
B
Bob Phillips
=sumproduct(--(rng1=condition1),--(rn2=condition2),--...,rng11)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)
--
HTH
Bob Phillips
(replace somewhere in email address with gmail if mailing direct)