Calculating totals

  • Thread starter Blissfully Ignorant
  • Start date
B

Blissfully Ignorant

I have two columns on a worksheet: "Project Codes" and "Totals." I would
like to have columns on another worksheet that will automatically total up
the different project numbers "A,B,C,etc." How do I do that?

Thanks in advance for your help,
Technically Handicapped
 
R

RagDyeR

Enter a *unique* list of your "Project Codes", starting in A2 of Sheet2.
In B2, enter this formula:

=SUMIF(Sheet1!A:A,A2,Sheet1!B:B)

And copy down as needed.
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

in message I have two columns on a worksheet: "Project Codes" and "Totals." I would
like to have columns on another worksheet that will automatically total up
the different project numbers "A,B,C,etc." How do I do that?

Thanks in advance for your help,
Technically Handicapped
 
Top