Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to use SUMIF to return sums between two values located in cells | Excel Worksheet Functions | |||
SUMIF | Excel Worksheet Functions | |||
Embedding a Sumif in a sumif | Excel Worksheet Functions | |||
SUMIF with Mutiple Ranges & Criteria | Excel Discussion (Misc queries) | |||
SUMIF - Range name to used for the "sum_range" portion of a SUMIF function | Excel Worksheet Functions |