Excel statistics

[ekonomija]

Hello,

I would like to count sum of numbers if there is a condition, for example

Column A:
Product RADIO
Product CELL PHONE
Product RADIO
Product RADIO

Column B:
100
200
90
90

So, how can I count how much money do I earn for product a (because money
values are different for the same product?)

Thank you very much!

Kindly regards,

 

[Wigi]

Hi

See http://www.ozgrid.com/Excel/sum-if.htm