R
Ronbo
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,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
number of posts but I can't seem to get it to work. I created the following;
SUMIF('YTD Data'!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