If your sheet names follow some sort of sequential naming pattern like
Sheet1, Sheet2, Sheet3 or Week1, Week2, Week3 then you can code the sheet
names directly into the formula.

Since your sheet names do not follow this kind of pattern then you'll have
to list the sheet names in a range of cells. So, let's assume you list the
sheet names in the range X1:X10.

Then to SUMIF across those sheets:

=SUMPRODUCT(SUMIF(INDIRECT("'"&X1:X10&"'!A2:A10"), A2,INDIRECT("'"&X1:X10&"'!F2:F10")))

This evaluates to a SUMIF for each sheet of the form:

SUMIF('sheet_name'!A2:A10,A2,'sheet_name'!F2:F10)

--
Biff
Microsoft Excel MVP


"Jeremy Lott" wrote in message
...
No, the names are numbers for vehicles in our fleet. The first is '2' and
the last is '76' and there are 54 others in between those two numbers (5,
11,
12, etc.)

I am creating a vehicle log for repairs and would like to total my
mechanic's time for each day on a time sheet for him on the first sheet,
and
track PO's for repairs and his maintenance hours for each vehicle on
separate
sheets.

"T. Valko" wrote:

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?


.



.