LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JT JT is offline
external usenet poster
 
Posts: 234
Default Count cells based upon criteria in other cells

The cells in column J contains donations made by various individuals. Cells
in column R contain certain member classifications. Am looking for a formula
that looks at column R, then counts the number of entries in the
corresponding cells in colum J for each member classsification. EX: in
column R there are three classifications: RB1, RB2, RB3. Need to count how
many donations in column J are made by each classification.

Many thanks!
 
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
Count if based on criteria within cells on another sheet --Viewpoint Excel Discussion (Misc queries) 1 August 21st 09 10:01 PM
Count text cells based on two criteria aet999 Excel Worksheet Functions 9 May 2nd 09 03:20 AM
Using a function to count cells based on multiple criteria Rae Excel Worksheet Functions 1 February 22nd 08 09:34 PM
count cells,containing text, based on more than one criteria? Sarfraz Excel Worksheet Functions 1 March 30th 07 11:20 PM
Count no. of nonblank cells in one column based on criteria of ano Beach Lover Excel Discussion (Misc queries) 9 February 19th 07 03:39 PM


All times are GMT +1. The time now is 10:35 AM.

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"