Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I am attempting to look at how many individuals during a specific time frame
(Column M) were admitted to our Level 2 program (Column J). The formula I have below does not seem to be working, as I end up with a "0" outcome, and I know that I have 4 people who were admitted to Level 2. Thus, I suspect there is something wrong with the formula I have written below. Any help would be appreciated: =SUMPRODUCT(--('ASAP Database'!$M$4:$M$5000=DATE(2008,1,1)),--('ASAP Database'!$M$4:$M$5000<=DATE(2008,12,31))*('ASAP Database'!$J$4:$J$5000="2"))*(ISNUMBER(('ASAP Database'!$J$4:$J$5000))) The second thing I want to do (in a separate formula), is to look at the income for this program. The fee is $300.00, so I assume I need to add "*300) somewhere to achieve that outcome. I couldn't seem to get that either: =SUMPRODUCT(--('ASAP Database'!$M$4:$M$5000=DATE(2008,1,1)),--('ASAP Database'!$M$4:$M$5000<=DATE(2008,12,31))*('ASAP Database'!$J$4:$J$5000="2"))*300,(ISNUMBER(('ASAP Database'!$J$4:$J$5000))) |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Problem using average or sum formulas | Excel Worksheet Functions | |||
Copying formulas - problem with the sum | Excel Worksheet Functions | |||
Problem with formulas | Excel Worksheet Functions | |||
Problem setting up formulas | New Users to Excel | |||
Pasting formulas problem | Excel Discussion (Misc queries) |