Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Weeknum + Conditional Sum
Hello,
I have a list which resembles the following example: A B C <Name <Price <Date <Name2 <Price2 <Date2 <Name3 <Price3 <Date3 The dates are in normal date formats (00-00-0000) I want Excel to sum up the Prices where which contain the name & week i insert.. For this i want to use the following formula: SUMPRODUCT(--($A$2:$A$4="Name"),--( ??? ),$A$2:$A$4) My question is what to insert at the questionmarks. I was thinking about using WEEKNUM($A$2:$A$4)="Week". I get the 'VALUE' error! Any help greatly appreciated. Greetz, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional Formatting using Formulas and WEEKNUM | Excel Discussion (Misc queries) | |||
WEEKNUM gone... | Excel Discussion (Misc queries) | |||
weeknum | Excel Discussion (Misc queries) | |||
Weeknum vs Conditional Formatting | Excel Discussion (Misc queries) | |||
Weeknum | Excel Worksheet Functions |