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,

 

[Snow-Munki]

thanks works a treat !!!