VLOOKUP may be?

[ab3d4u]

I have a PR spreadsheet with 12 worksheets labeled by month - i have
names and salary amount for each month separate. Presently there are
only 35 employees. In July we had about 60, Aug 50 Sept 40 Oct till end
of June we will have 35 permanent employees . For labor negatation
purposes, management wants to work on figures involving the current 35
employees. I would like to create a "summary" worksheet that selects
names that appear on the three worksheets in one column and next column
either by month or the total YTD paid for the selcted employee.The extra
help are seasonal while we operate with 35 employees. By way of example:
worksheet July in col A has names, in B has amounts, the same format for
all consecutive months. Our fiscal year is July to June. Does any one
know an easy way to do this? Thanks in advance

 

[Guest]

I recommend typing or pasting the 35 names in a column (maybe A" on your
summary tab and then using the SUMIF function to get the totals in column B.
It would be a fairly lengthy formula but should do the trick. Or if you want
to show all of the months on the summary tab and then total them at the right
you could also use the SUMIF function in each position for each person and
month.

You could also use named ranges to make the ranges on each tab a little
easier to deal with. For example, if you named each column of names using
the month followed by N (e.g. JulN, AugN, etc.) and each column of values
with the month followed by S, the formula in cell B2 on your summary tab
would look something like:

=SUMIF(JulN,A2,JulS) + SUMIF(AugN,A2,AugS) + SUMIF(SepN,A2,SepS) + ....

The formula could be copied down for the rest of the names.

Will

 

[ab3d4u]

I recommend typing or pasting the 35 names in a column (maybe A" on your

summary tab and then using the SUMIF function to get the totals in
column B.
It would be a fairly lengthy formula but should do the trick. Or if
you want
to show all of the months on the summary tab and then total them at the
right
you could also use the SUMIF function in each position for each person
and
month.

You could also use named ranges to make the ranges on each tab a little

easier to deal with. For example, if you named each column of names
using
the month followed by N (e.g. JulN, AugN, etc.) and each column of
values
with the month followed by S, the formula in cell B2 on your summary
tab
would look something like:

=SUMIF(JulN,A2,JulS) + SUMIF(AugN,A2,AugS) + SUMIF(SepN,A2,SepS) +
....

The formula could be copied down for the rest of the names.

Will

:
-

I have a PR spreadsheet with 12 worksheets labeled by month - i have
names and salary amount for each month separate. Presently there are
only 35 employees. In July we had about 60, Aug 50 Sept 40 Oct till
end
of June we will have 35 permanent employees . For labor negatation
purposes, management wants to work on figures involving the current
35
employees. I would like to create a "summary" worksheet that selects
names that appear on the three worksheets in one column and next
column
either by month or the total YTD paid for the selcted employee.The
extra
help are seasonal while we operate with 35 employees. By way of
example:
worksheet July in col A has names, in B has amounts, the same format
for
all consecutive months. Our fiscal year is July to June. Does any one
know an easy way to do this? Thanks in advance

What a marvelous idea and neat formula. Thank you very much Will.