| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to use sumif function to check date in 1 sheet is < 2 sheet
I am trying to add a total in 2 sheet if date in 1 sheet is <= particular
criteria. the following is my function call =SUMIF(List!$B$2:$B$65536,"<= A2",List!$C$2:$C$65536) Please explain why it does not work and how to make it work. The answer at present comes to zero only. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| IF function for scheduling tool with outlook integration | Excel Worksheet Functions | |||
| basic sumif function help (urgent) | Excel Worksheet Functions | |||
| Help with SUMIF function | Excel Discussion (Misc queries) | |||
| Excel option to store trendline's coefficients in cells for use | Charts and Charting in Excel | |||
Threaded Mode
