Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
multiple SUMIF criteria | Excel Worksheet Functions | |||
SUMPRODUCT / SUMIF on Multiple Worksheets with Multiple Criteria | Excel Discussion (Misc queries) | |||
SUMIF with multiple criteria | Excel Discussion (Misc queries) | |||
SumIf with Multiple Criteria | Excel Worksheet Functions | |||
SUMIF with multiple criteria for multiple columns to sum a single | Excel Programming |