Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 989
Default Summing formula

Can someone help me please?

I know pivots tables will provide this information but they are to memory
intensive.

I want to be able sum the figures in a column if another column meets a text
value in that same row.

Orange, 2
Lemon, 4
Apple, 7
Peach, 3
Orange, 5

So I get a SUM result for Oranges as 7

Thanks

--
Mark
 
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
Find value in array Brook6 Excel Worksheet Functions 26 January 30th 07 09:40 PM
Summing a column with formula value... Jay Excel Worksheet Functions 1 September 6th 06 10:52 PM
What formula will eliminate the cell with #N/A when summing? Nunzio Excel Worksheet Functions 2 August 12th 06 06:21 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
summing formula Ron Woolley New Users to Excel 3 January 28th 06 05:40 PM


All times are GMT +1. The time now is 10:19 PM.

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

About Us

"It's about Microsoft Excel"