I have a worksheet with over 3 colums.
column A - product name = PILLI
column b = value of 1 - 50
column c - date = 1 Apr to 31May
i am using the following formula to caluclate the count of PILLI
sumproduct((trim($a10:$a500)="PILLI")*($b10:$b500<=7)*($C10:$C500>=datevalue("4/1/2012")*($c10:$c500<=datevalue("4/30/2012))))
I fid that the formula cannot refer to the specified date period. can anyone help, please.
Bookmarks