Hi,

Unfortunately SUMIF cannot be used across sheets.
Assuming you want to put the result in Start, a workaround would be to
select all sheets except Sheet1 and enter the following formula in cell A1
(or the cell of your choice) :-
=IF(L3="IPA",F3,0)

Then enter in A1 in Start :-
=IF(L3="IPA",F3,0)+SUM(Start:Finish!A1)


Hope this helps,
Matt
"Cbh35711" wrote:

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