Sum if two conditions.

  • Thread starter Thread starter ldiaz
  • Start date Start date
L

ldiaz

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
 
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
 
Back
Top