software

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

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

quot;Rayquot; wrote:

gt; Hi,
gt;
gt; I have a sheet with many cost codes (101,102,103... ,201,202....) which I
gt; update daily. I want to be able to automatically total each cost code into a
gt; summary sheet (where each code is listed). Is there any easy way to do this?
gt;
gt;
gt; Thanks
gt;
gt;
gt; Ray

Thanks

That's perfectRay

quot;bpeltzerquot; wrote:

gt; Check the SUMIF function. You'll wind up with a SUMIF next to each cost code
gt; on the summary sheet, something like =sumif('Detail Sheet'!A:A,a2,'Detail
gt; Sheet'!B:B).
gt;
gt; quot;Rayquot; wrote:
gt;
gt; gt; Hi,
gt; gt;
gt; gt; I have a sheet with many cost codes (101,102,103... ,201,202....) which I
gt; gt; update daily. I want to be able to automatically total each cost code into a
gt; gt; summary sheet (where each code is listed). Is there any easy way to do this?
gt; gt;
gt; gt;
gt; gt; Thanks
gt; gt;
gt; gt;
gt; gt; Ray