| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
another sumifs plea
I'm struggling to convert a sumifs line from 2007 to excel 2003.
The line I have working correctly in 2007 is: =SUMIFS('Washing MC Rental'!$K$4:$K$21,'Washing MC Rental'!$Q$4:$Q$21,"= 0.00",'Washing MC Rental'!$L$4:$L$21,"28/2/2010")-SUMIFS('Washing MC Rental'!$K$4:$K$21,'Washing MC Rental'!$Q$4:$Q$21,"= 0.00",'Washing MC Rental'!$L$4:$L$21,"31/3/2010") Can any one please help me to put this into 2003? Best Regards Dave |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I need help creating a score sheet with weighted values. Help Plea | Excel Worksheet Functions | |||
| Entering multiple barcode using Talbar program, having issue plea | Excel Worksheet Functions | |||
| Making two different date formats compatible - help requested plea | Excel Discussion (Misc queries) | |||
| How can I replace zeros with blank spaces during calculations plea | Excel Worksheet Functions | |||
| the autosum do not working propely ##### THAT WHAT APPEARS PLEA. | Excel Discussion (Misc queries) | |||
Threaded Mode
