sumif

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Phil - 20 Mar 2006 19:41 GMT

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

Reply to this Message

CLR - 20 Mar 2006 20:11 GMT

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

> 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
[quoted text clipped - 4 lines]
>
> phil

Reply to this Message

Phil - 20 Mar 2006 20:26 GMT

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??

> 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
[quoted text clipped - 13 lines]
> >
> > phil

Reply to this Message

CLR - 21 Mar 2006 03:17 GMT

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

> 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
[quoted text clipped - 17 lines]
> > >
> > > phil

Reply to this Message