| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum if Week Number and style is equal to any condition
Could you help me on this?
I want to make a sum if Range is a week number and if style is Equal to CONC-92 or CONC-45 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 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 Week Number and style is equal to any condition
With the text Week# in A1, the other text in B1:E1
Row 2 has: 49, 5,5,10,10 To sum for week = 49 and type is CON-92 SUMIF(A2:A5,49,B2:B5)+SUMIF(A2:A5,49,D2:D5) OR =SUMIF($A$2:$A$5,G1,$B$2:$B$5)+SUMIF($A$2:$A$5,G1, $D$2:$D$5) if G1 hold the value 49 Copy down to the next cell with G2 holding the value 50 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ldiaz" wrote in message ... Could you help me on this? I want to make a sum if Range is a week number and if style is Equal to CONC-92 or CONC-45 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 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum if Week Number and style is equal to any condition
Thanks for your help,
LD -- Lorenzo DÃ*az Cad Technician "Bernard Liengme" wrote: With the text Week# in A1, the other text in B1:E1 Row 2 has: 49, 5,5,10,10 To sum for week = 49 and type is CON-92 SUMIF(A2:A5,49,B2:B5)+SUMIF(A2:A5,49,D2:D5) OR =SUMIF($A$2:$A$5,G1,$B$2:$B$5)+SUMIF($A$2:$A$5,G1, $D$2:$D$5) if G1 hold the value 49 Copy down to the next cell with G2 holding the value 50 best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ldiaz" wrote in message ... Could you help me on this? I want to make a sum if Range is a week number and if style is Equal to CONC-92 or CONC-45 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 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 range of a week if condition is equal to.. | Excel Discussion (Misc queries) | |||
| group sales by week and week number | Excel Discussion (Misc queries) | |||
| Accounting Style Number Button | Excel Worksheet Functions | |||
| I need week number in excell from a date, first week must be mini. | Excel Discussion (Misc queries) | |||
| How to format a number in Indian style in Excel? | Excel Discussion (Misc queries) | |||
Hybrid Mode
