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?


.



.