Thread: Year to date sales
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pierre Pierre is offline
external usenet poster
  
Posts: 193
Default Year to date sales
On Jan 18, 4:42*pm, "T. Valko" wrote:
Try it like this:

=SUMPRODUCT((YEAR('[CST100.xls]Summary'!$S$8:$S$800)=2008)*'[CS0107.xls]Sum*mary'!$M$8:$N$800)

--
Biff
Microsoft Excel MVP



Thank you kind Sir.

Pierre

Reply With QuoteReply With Quote