Sum if two conditions.
 

hello all.

I want to make a sum if Range is a week number and if style is Equal to
CONC-92 or CONC-45
I got this formula in a previous post:
With the text Week# in A1, the other text in B1:E1
=SUMIF($A$2:$A$5,G1,$B$2:$B$5)+SUMIF($A$2:$A$5,G1, $D$2:$D$5) but it does not
work since it is for a specific column and on the pivot table some times,
datas are viceversa, also I have more than four columns ,

I want results like this:
Week# 49 Week# 50
CONC-92= 27 CONC-92= 30
CONC-45= 27 CONC-45= 30


Datas are in a pivot table and...
Pivot table looks like this:
Week# CONC-92 CONC-45 CONC-92 CONC-45 ...may vary, maybe -45 or -92
49 5 5 10 10
49 2 2 10 10
50 5 5 10 10
50 5 5 10 10


--
Lorenzo DÃ*az
Cad Technician

Sum if two conditions.
 

Try this formula
=SUMPRODUCT(--($B$1:$E$1="CONC-92")*--($A$2:$A$5=$H$1)*$B$2:$E$5)


H1 is the week number

On Dec 11, 5:24 pm, ldiaz wrote:
hello all.

I want to make a sum if Range is a week number and if style is Equal to
CONC-92 orCONC-45
I got this formula in a previous post:
With the text Week# in A1, the other text in B1:E1
=SUMIF($A$2:$A$5,G1,$B$2:$B$5)+SUMIF($A$2:$A$5,G1, $D$2:$D$5) but it does not
work since it is for a specific column and on the pivot table some times,
datas are viceversa, also I have more than four columns ,

I want results like this:
Week# 49 Week# 50
CONC-92= 27 CONC-92= 30CONC-45= 27 CONC-45= 30

Datas are in a pivot table and...
Pivot table looks like this:
Week# CONC-92 CONC-45 CONC-92 CONC-45...may vary, maybe -45 or -92
49 5 5 10 10
49 2 2 10 10
50 5 5 10 10
50 5 5 10 10

--
Lorenzo Díaz
Cad Technician