Counting items in one column based on criteria in another

K

kmc103

I'm trying to count the number of rows in a column which meet criteria
identified in another column. I'm creating a payroll template where one
column identifies whether the position is full-time or part-time. In my
first month of payroll I want to be able to count the number payroll amounts
which are classified as full-time. I also want to ignore any zeroes. Any
help would be greatly appreciated. In using Windows 2003
 
K

kmc103

Unfortunately that didn't work. I tried the formula and it gave me a zero
value. Also, I'm looking to count the # of cells which match the criteria.
I think sumproduct would give me the sum. Thanks - I appreciate the response
 
D

David Biddulph

If that formula gave a zero result it means that you have no rows in which
column A ="full-time" and column B>0. If you have any rows which meet both
those criteria, that formula will count them.
 
K

kmc103

It does work - I was missing the dashes in the formula. Thanks to both of
you for your help!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Autonumber field in Excel that behaves the same as Access 0
'Data Type Mismatch In Criteria Expression' error when using 'Count' in query Design; Help! 0
Trying to count based on multiple criteria & cell comparisons 4
Count and Sum Functions based on multiple column criteria 1
Multiple criteria in same column 6
Counting unique values based on 2 columns 3
Using countif with multiple criteria 0
Counting Multiple Records by specific criteria 5

Top