I am looking to sum all values in column F
on worksheets 2-30

Are the *real* sheet names 2, 3, 4, 5, etc., 30 ?

--
Biff
Microsoft Excel MVP


"Jeremy Lott" <Jeremy wrote in message
...
Okay, so I am looking to sum all values in column F on worksheets 2-30
when
the value in column A on worksheets 2-30 equals the value in A2 on
worksheet
1. Is this still a sumif equation? Please help!

"T. Valko" wrote:

I'd heard that SUM works over multiple worksheets, but does SUMIF?

By itself, SUMIF can't be used across multiple sheets unless you do
something like this:

=SUMIF(First_sheet)+SUMIF(Second_sheet)+SUMIF(Thir d_sheet)+etc., etc.

However, you can use SUMIF combined with other functions to do this. Or,
depending on the application you might be able to use a FREQUENCY
formula.

How about some specific details *including* the sheet names. The sheet
names
can make a big difference as to how "easy" this is to implement.

--
Biff
Microsoft Excel MVP


"luttona" wrote in message
...
I'm trying to create a summary worksheet involving figures from other
worksheets, but SUMIF is giving me problems. I'd heard that SUM works
over
multiple worksheets, but does SUMIF?


.