View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ronbo Ronbo is offline
external usenet poster
 
Posts: 162
Default Multiple Criteria for SumIf

I would like to sum the total of a category between two dates. There are a
number of posts but I can't seem to get it to work. I created the following;

SUMIF('YTD Data'!D:D,M3,'YTD Data'!B:B)&SUMIF('YTD Data'!A:A,"="&M1,'YTD
Data'!B:B)-SUMIF('YTD Data'!A:A,""&M2,'YTD Data'!B:B)

But it does not work very good because the sum is "text", it can not be
formated and if 0 it gives a "text value".

Any help is appreciated.
Ronbo