Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sum scattered entries on an Excel worksheet?
I would like to be able to locate all of one type of entry on a spreadsheet
and sum the accompanying entered values. Example: Users enter mutliple entries for SMITH job in the NAME column(A) and a value of 1.5 in the HOURS column(B) associated with it. They do this various times on this worksheet, but not in sequence. How can I LOCATE all of the scattered SMITH entries in the NAME column and SUM the associated VALUES in the HOURS column, giving me all of the hours entered for the SMITH job? EXCEL 2002 SP3 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I sum scattered entries on an Excel worksheet?
Use the SUMIF function - see help for specifics, along the lines of
=SUMIF(A:A,"SMITH",B:B) HTH, Bernie MS Excel MVP "bassmanfranc" wrote in message ... I would like to be able to locate all of one type of entry on a spreadsheet and sum the accompanying entered values. Example: Users enter mutliple entries for SMITH job in the NAME column(A) and a value of 1.5 in the HOURS column(B) associated with it. They do this various times on this worksheet, but not in sequence. How can I LOCATE all of the scattered SMITH entries in the NAME column and SUM the associated VALUES in the HOURS column, giving me all of the hours entered for the SMITH job? EXCEL 2002 SP3 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I find duplicate entries in a column in an Excel worksheet? | Excel Discussion (Misc queries) | |||
Best way to total scattered data? | Excel Discussion (Misc queries) | |||
How do I sum scattered entries on an Excel worksheet? | Excel Worksheet Functions | |||
Checking for Empty Scattered Cells | Excel Programming | |||
Labelling at xy scattered chart | Charts and Charting in Excel |