Excel help please !!

[Snow-Munki]

Hi,

I have a grid like so:




And I want a formula which can calculate for Type A the totaly numer of CPU's and total amount of RAM.

So A would be 6 CPU and 9216 RAM

Any ideas ?

Thanks,

 

[Columbo]

Pivot table would do the same mate with 'sum' of cpu & 'sum' of RAM.

 

[Ice Globe]

=SUMIF(A2:A9,"A",B2:B9)
=SUMIF(A2:A9,"A",C2:C9)

 

[Snow-Munki]

thanks works a treat !!!