LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3
Default Summing/Counting Data in One Column Based on Criteria Another Col

This level of Excel complexity is a little above my skills, and am hoping
that someone can help.

I have numbered data in one range of cells (e.g., b1:b158) and alpha
criteria in another (e.g., "apples", "oranges", "pears" in c1:c158). I am
trying to sum the data in cells b1:b158 based on the criteria in cells
c1:c158, and put the result in a third cell. So for example, the sum of the
numbers in column b would be put in cell d1 if the criteria in c1:c158 was
equal to "apples"; the sum of the numbers in b would be put in d2 if the
criteria in c1:c158 was "oranges", etc.

Anyone have any suggestions? Thanks in advance for your help.
--
agilek9
 
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
Counting items in one column based on criteria in another kmc103 Excel Worksheet Functions 4 May 15th 08 09:17 PM
summing column c based an column a criteria ndforty Excel Worksheet Functions 2 May 3rd 07 06:57 PM
summing values in a data table based on criteria in another column Dave F Excel Worksheet Functions 7 August 26th 06 04:36 PM
Summing data based on criteria Wendy Excel Discussion (Misc queries) 2 August 1st 06 04:07 PM
Counting & Summing based on criteria on another column Chicago D Excel Discussion (Misc queries) 2 August 25th 05 06:58 PM


All times are GMT +1. The time now is 02:34 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"