Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Having an issue with suming using the Conditional sum wizard. At the bottom
is the formula. Have 3 criteria, a specific code number (shown as V13 below ) and also fall between 2 dates, The date criteria is typically like: =1/1/08 & <=1/31/08 shown as <=W13 and =X13. The problem is that it always returns zero as the sum and I know its not zero. If I change the date criteria to just =1/1/08 (=X13) it will work but returns the sum for all the dates equal to or greater than 1/1/08. Any suggestions would be helpful? =SUM(IF($B$2:$B$1423=V13,IF($A$2:$A$1423<=W13,IF($ A$2:$A$1423=X13,$H$2:$H$1423,0),0),0)) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Multiple range selection issue | Excel Discussion (Misc queries) | |||
I feel so dumb - please help - this is a Range issue | Excel Worksheet Functions | |||
Strange named range issue with multiple workbooks | Excel Discussion (Misc queries) | |||
Date issue | Excel Worksheet Functions | |||
Conditonal Format with a date format | Excel Discussion (Misc queries) |