| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Excel Formula Help
Can excel add columns on multiple worsheets in a workbook if certian criteria are met? For example I have a workbook with worksheets 1-31 that contain all my data and on sheet 32 I want to compile that data into one spreadsheet, I have tried using sumif and I get a ref error, here is the formula I am using =IF('1:31'!K7:K200=98,"sum+'1:31'!F7:F200",0).... -- carmonaj ------------------------------------------------------------------------ carmonaj's Profile: http://www.msusenet.com/member.php?userid=2933 View this thread: http://www.msusenet.com/t-1870580011 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Formula in an Excel comment | Excel Discussion (Misc queries) | |||
| How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
| Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
| Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions | |||
Threaded Mode
