Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto sum
Hi,
I have a sheet with many cost codes (101,102,103... ,201,202....) which I update daily. I want to be able to automatically total each cost code into a summary sheet (where each code is listed). Is there any easy way to do this? Thanks Ray |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto sum
Check the SUMIF function. You'll wind up with a SUMIF next to each cost code
on the summary sheet, something like =sumif('Detail Sheet'!A:A,a2,'Detail Sheet'!B:B). "Ray" wrote: Hi, I have a sheet with many cost codes (101,102,103... ,201,202....) which I update daily. I want to be able to automatically total each cost code into a summary sheet (where each code is listed). Is there any easy way to do this? Thanks Ray |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Auto sum
Thanks
That's perfect Ray "bpeltzer" wrote: Check the SUMIF function. You'll wind up with a SUMIF next to each cost code on the summary sheet, something like =sumif('Detail Sheet'!A:A,a2,'Detail Sheet'!B:B). "Ray" wrote: Hi, I have a sheet with many cost codes (101,102,103... ,201,202....) which I update daily. I want to be able to automatically total each cost code into a summary sheet (where each code is listed). Is there any easy way to do this? Thanks Ray |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto tab- Auto fill | New Users to Excel | |||
Macro for Auto Fill | Excel Discussion (Misc queries) | |||
Averaging Values in Auto Filter | Excel Worksheet Functions | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |