Sum by week number and if style is Equal to :CONC-92 or CONC-45

[ldiaz]

hello all.

I want to make a sum by 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

 

[Tim879]

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

Assumes that you have the data organized as you described in your
post. $H$1 is the week number.

Just replace CONC-92 with CONC-45 or reference a cell containing that
value to modify the formula.

 

[ldiaz]

Hi Tim, this works perfectly

Thank you so much for your help
--
Lorenzo Díaz
Cad Technician

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

Assumes that you have the data organized as you described in your
post. $H$1 is the week number.

Just replace CONC-92 with CONC-45 or reference a cell containing that
value to modify the formula.