#1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 20
Default 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,

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 396
Default 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,

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Statistics and Excel James7100 Excel Worksheet Functions 2 September 13th 07 08:54 PM
Statistics in Excel rakbhat Excel Discussion (Misc queries) 1 September 27th 06 12:23 PM
Statistics in Excel? [email protected] Charts and Charting in Excel 1 April 26th 06 01:01 PM
Please help with Statistics Formulas in Excel Fonz Excel Discussion (Misc queries) 10 April 9th 06 03:22 PM
excel and statistics functions sjvicker Excel Worksheet Functions 4 February 16th 06 03:51 AM


All times are GMT +1. The time now is 08:45 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"