Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 15th 08, 07:04 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 3
Default Counting items in one column based on criteria in another

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

  #2   Report Post  
Old May 15th 08, 07:15 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Nov 2006
Posts: 15,768
Default Counting items in one column based on criteria in another

*Maybe* this....

=SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000))


--
Biff
Microsoft Excel MVP


"kmc103" wrote in message
...
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



  #3   Report Post  
Old May 15th 08, 07:45 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 3
Default Counting items in one column based on criteria in another

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

"T. Valko" wrote:

*Maybe* this....

=SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000))


--
Biff
Microsoft Excel MVP


"kmc103" wrote in message
...
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




  #4   Report Post  
Old May 15th 08, 08:02 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Counting items in one column based on criteria in another

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

"kmc103" wrote in message
...
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

"T. Valko" wrote:

*Maybe* this....

=SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000))


--
Biff
Microsoft Excel MVP


"kmc103" wrote in message
...
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






  #5   Report Post  
Old May 15th 08, 09:17 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: May 2008
Posts: 3
Default Counting items in one column based on criteria in another

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

"David Biddulph" wrote:

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

"kmc103" wrote in message
...
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

"T. Valko" wrote:

*Maybe* this....

=SUMPRODUCT(--(A1:A100="full-time"),--(B1:B1000))


--
Biff
Microsoft Excel MVP


"kmc103" wrote in message
...
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








Reply
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 Unique Items with Multiple Criteria Joe Gieder Excel Worksheet Functions 3 March 5th 07 11:08 PM
Counting Unique Items with Multiple Criteria Teethless mama Excel Worksheet Functions 0 March 3rd 07 12:12 AM
Counting Unique Items with Multiple Criteria Ron Coderre Excel Worksheet Functions 0 March 2nd 07 11:51 PM
sum items in a column based on criteria located in other columns Kurt Excel Discussion (Misc queries) 1 August 2nd 06 05:12 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:47 PM.

Powered by vBulletin® Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
Copyright 2004-2017 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017