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