Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
USChad
 
Posts: n/a
Default Counting cells that meet 2 differnet criteria

I need the number of cells in a database that meet two differnt criteria.
First it has to have a certain number in column A....such as 372647...then it
has to have certain data in column F... such as "NON CUSTOMER".. i have tried
several different formulas and nothing seems to be coming up correct for me.
Any help is appreachiated.

Thanks
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default

SUMPRODUCT(--(A1:A10000=372647),--(F1:F10000="NON CUSTOMER")
Just change the row numbers to fit your data.


--
Regards,
Dave


"USChad" wrote:

I need the number of cells in a database that meet two differnt criteria.
First it has to have a certain number in column A....such as 372647...then it
has to have certain data in column F... such as "NON CUSTOMER".. i have tried
several different formulas and nothing seems to be coming up correct for me.
Any help is appreachiated.

Thanks

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 the number of cells meeting conditional formating criteria Jeff Excel Worksheet Functions 4 July 9th 05 02:18 AM
copying cells based on criteria tdro Excel Worksheet Functions 0 June 15th 05 03:17 PM
Counting empty cells within a range of cells Rosehill - ExcelForums.com New Users to Excel 0 April 7th 05 01:47 AM
Print cells that meet conditional formatting criteria Roundy Excel Discussion (Misc queries) 1 December 14th 04 01:13 AM
Counting rows based on criteria in multiple cells Margaret Excel Discussion (Misc queries) 11 December 3rd 04 12:04 AM


All times are GMT +1. The time now is 02:06 PM.

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"