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

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

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