sumif
 

I'm trying to use one sumif formula to capture YTD personel info from several
tabs (Jan-Dec) within a workbook with no success. The criteria is the
personel name. Because people come and go from the company the data can't
simply be pulled from the same cell from the different tabs. Currently, I'm
adding a sumif (Jan) + sumif (Feb) + etc to be able to achieve my objective.
There's gotta be a better way! Any suggestions? Thanks.

phil

sumif
 

The best "better way" that I can suggest would be to change over to a
single-sheet database instead of one sheet for each month. Then the SUMIF
and/or AutoFilter function would be simple, and specific-month reports could
be easily reproduced if desired.

hth
Vaya con Dios,
Chuck, CABGx3



"Phil" wrote:

I'm trying to use one sumif formula to capture YTD personel info from several
tabs (Jan-Dec) within a workbook with no success. The criteria is the
personel name. Because people come and go from the company the data can't
simply be pulled from the same cell from the different tabs. Currently, I'm
adding a sumif (Jan) + sumif (Feb) + etc to be able to achieve my objective.
There's gotta be a better way! Any suggestions? Thanks.

phil

sumif
 

unfortunately i need to keep the format as is. any other
suggestions?...don't know if sumif is the wrong route or i need to combine
this formala with another??

"CLR" wrote:

The best "better way" that I can suggest would be to change over to a
single-sheet database instead of one sheet for each month. Then the SUMIF
and/or AutoFilter function would be simple, and specific-month reports could
be easily reproduced if desired.

hth
Vaya con Dios,
Chuck, CABGx3



"Phil" wrote:

I'm trying to use one sumif formula to capture YTD personel info from several
tabs (Jan-Dec) within a workbook with no success. The criteria is the
personel name. Because people come and go from the company the data can't
simply be pulled from the same cell from the different tabs. Currently, I'm
adding a sumif (Jan) + sumif (Feb) + etc to be able to achieve my objective.
There's gotta be a better way! Any suggestions? Thanks.

phil

sumif
 

ONly other thing I can suggest is to use a regular SUMIF on each sheet, just
for that sheet, and reference the name to a cell on your sheet1Master sheet,
and on that sheet, you can set the name criteria for all sheets, and sum the
sums.......

Vaya con Dios,
Chuck, CABGx3


"Phil" wrote in message
...
unfortunately i need to keep the format as is. any other
suggestions?...don't know if sumif is the wrong route or i need to combine
this formala with another??

"CLR" wrote:

The best "better way" that I can suggest would be to change over to a
single-sheet database instead of one sheet for each month. Then the
SUMIF
and/or AutoFilter function would be simple, and specific-month reports
could
be easily reproduced if desired.

hth
Vaya con Dios,
Chuck, CABGx3



"Phil" wrote:

I'm trying to use one sumif formula to capture YTD personel info from
several
tabs (Jan-Dec) within a workbook with no success. The criteria is the
personel name. Because people come and go from the company the data
can't
simply be pulled from the same cell from the different tabs.
Currently, I'm
adding a sumif (Jan) + sumif (Feb) + etc to be able to achieve my
objective.
There's gotta be a better way! Any suggestions? Thanks.

phil