SUMIF with several, 10, conditions
 

I have a source data in several colums and raws. I am trying to sum amounts
that satisfy several conditions.

SUMIF with several, 10, conditions
 

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
"AZ" wrote:

I have a source data in several colums and raws. I am trying to sum amounts
that satisfy several conditions.

SUMIF with several, 10, conditions
 

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.

"AZ" wrote:

I have a source data in several colums and raws. I am trying to sum amounts
that satisfy several conditions.

SUMIF with several, 10, conditions
 

I think array formula's are the solution here.

"AZ" wrote in message
...
I have a source data in several colums and raws. I am trying to sum amounts
that satisfy several conditions.

SUMIF with several, 10, conditions
 

=sumproduct(--(rng1=condition1),--(rn2=condition2),--...,rng11)

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"AZ" wrote in message
...
I have a source data in several colums and raws. I am trying to sum
amounts
that satisfy several conditions.