| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sumif with multiple worksheets
I've got a file with many worksheets and a summary page in the beginning.
I'd like to be able to use the SUMIF function, or another, to add certain worksheets and not others. I keep getting #value errors. This is the formula I'm using. =SUMIF(Start:Finish!L3,"IPA",Start:Finish!F3) Start and finish are worksheets i used to group the others together. This is what I'm hoping this formula will do. Look at all the worksheets in cell L3, if that worksheet has IPA in that cell add the value of F3 in the cell that the formula is located. Am I using the correct formula and just typing it wrong or should I be using a different type of formula altogether? Thanks for any help Cbh35711 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| What is the quickest method to insert & name multiple worksheets . | Excel Worksheet Functions | |||
| Adding multiple worksheets | Excel Worksheet Functions | |||
| Sort rows across multiple worksheets - Excel 2003 | Excel Worksheet Functions | |||
| how do I arrange multiple worksheets from the same workbook | Excel Discussion (Misc queries) | |||
| Countif with multiple criteria and multiple worksheets | Excel Worksheet Functions | |||
Threaded Mode
