| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Sum range of a week if condition is equal to..
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: Date CONC-92 CONC-45 CONC-92 CONC-45 12/7 5 5 10 10 12/8 2 2 10 10 12/9 5 5 10 10 12/10 5 5 10 10 please help -- Lorenzo DÃ*az Cad Technician |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum range of a week if condition is equal to..
You will need a helper column with =WEEKNUM(A2) where A2 is the first date
I cannot get SUMIF or SUMPRODUCT to work with WEEKNUM best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ldiaz" wrote in message ... 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: Date CONC-92 CONC-45 CONC-92 CONC-45 12/7 5 5 10 10 12/8 2 2 10 10 12/9 5 5 10 10 12/10 5 5 10 10 please help -- Lorenzo Díaz Cad Technician |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum range of a week if condition is equal to..
That is because WEEKNUM will not return an array of values, so it's of no
use to SP. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bernard Liengme" wrote in message ... You will need a helper column with =WEEKNUM(A2) where A2 is the first date I cannot get SUMIF or SUMPRODUCT to work with WEEKNUM best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ldiaz" wrote in message ... 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: Date CONC-92 CONC-45 CONC-92 CONC-45 12/7 5 5 10 10 12/8 2 2 10 10 12/9 5 5 10 10 12/10 5 5 10 10 please help -- Lorenzo Díaz Cad Technician |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Sum range of a week if condition is equal to..
Agreed
-- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "Bob Phillips" wrote in message ... That is because WEEKNUM will not return an array of values, so it's of no use to SP. -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Bernard Liengme" wrote in message ... You will need a helper column with =WEEKNUM(A2) where A2 is the first date I cannot get SUMIF or SUMPRODUCT to work with WEEKNUM best wishes -- Bernard V Liengme Microsoft Excel MVP www.stfx.ca/people/bliengme remove caps from email "ldiaz" wrote in message ... 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: Date CONC-92 CONC-45 CONC-92 CONC-45 12/7 5 5 10 10 12/8 2 2 10 10 12/9 5 5 10 10 12/10 5 5 10 10 please help -- Lorenzo Díaz Cad Technician |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Equal to previous cell and named range | Excel Worksheet Functions | |||
| want highlight when all cells in range are equal | Excel Worksheet Functions | |||
| Determine which cells from a specific range equal a certain sum | Excel Worksheet Functions | |||
| Help with week day count with range | Excel Worksheet Functions | |||
| How do I select a range if one cells contents is equal to another | Excel Discussion (Misc queries) | |||
Linear Mode
