Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
SUM if the conditions are met | Excel Worksheet Functions | |||
2 Conditions + Sum of a colum matching those conditions | Excel Worksheet Functions | |||
CF with 4 conditions | Excel Worksheet Functions | |||
shade cells based on conditions - i have more than 3 conditions | Excel Worksheet Functions | |||
How to multiple conditions to validate more than 2 conditions to . | Excel Worksheet Functions |