Weeknum + Conditional Sum
Hi, Thanks for the reply!
When using =Datevalue(G2) however, it also gives a value error!
I'm going home now, so i won't read it untill tomorrow. Thanks for any effort.
"Joel" wrote:
"Week" need to be a datevalue.
WEEKNUM($A$2:$A$4)=Weeknum(DateValue("10/20/08")).
"Gunti" wrote:
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,
|