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