Excel statistics
 

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,

Excel statistics
 

Hi

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


--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"ekonomija" wrote:

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,