#1
|
|||
|
|||
counting cells to the right of criteria
What I would like to do is count the number of cells that are greater than zero in a column that fits criteria in the column to it's left. I.E. in column A; I have 1st to 4th Quarters for all club members, In column B; I have the dues they paid in each quarter. I would like a count of the number of cells that are more than zero for each member in the 1st quarter etc |
#2
|
||||
|
||||
Perhaps a Pivot Table might fit your needs?
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
I don't know anything at all about a pivot function but I did google it and I don't think that it would fit my need; I was thinking more of a combination of the IF and count functions, if that is at all possible. I have a basic knowledge of spreadsheets, all self taught and mostly figure things out by trial and error.
|
#4
|
|||
|
|||
Hi
Look into the COUNTIF & COUNTIFS Functions |
#5
|
|||
|
|||
countifs did it; thank you so much. I googled "countifs" and copied the formula from an example and then just had to add my range and criteria; Love this site
|
#6
|
|||
|
|||
Deleted Post
Last edited by Kevin@Radstock; 11-05-2015 at 03:03 PM. |
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Matching Criteria against a range when criteria is not in contiguous cells?? | GMorris | Excel | 9 | 08-20-2014 02:15 AM |
Counting Color in Cells | Alaska1 | Excel | 7 | 07-28-2013 04:36 PM |
Counting cells with multiple complex criteria | TishyMouse | Excel | 12 | 12-06-2012 05:05 AM |
Change values in cells based on criteria | SaneMan | Excel Programming | 2 | 02-02-2012 07:58 AM |
Selecting blank cells in criteria | apolloman | Excel | 6 | 08-24-2011 05:38 AM |