|
|
#1
11-05-2015, 08:50 AM
|
|||
|
|||
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
11-05-2015, 09:27 AM
|
||||
|
||||
|
Perhaps a Pivot Table might fit your needs?
__________________
Using O365 v2503 - 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
11-05-2015, 10:35 AM
|
|||
|
|||
|
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
11-05-2015, 10:57 AM
|
|||
|
|||
|
Hi
Look into the COUNTIF & COUNTIFS Functions
|
|
#6
11-05-2015, 11:52 AM
|
|||
|
|||
|
Deleted Post
Last edited by Kevin@Radstock; 11-05-2015 at 03:03 PM.
|
|
|
|
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 |
Windows 7 
Office 2007
Linear Mode
