LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Mark G
 
Posts: n/a
Default How do I count based on two conditions?

Hi there. I have a long lists of data to sort though and I am trying to write
a formula that counts that number of entries for a company with a certain
condition entered in another column. For instance

Company name Condition
Big Corp operatonal
Small corp operational
Big Corp non-operational

How do I count where Big Corp is operational and where it is non-operational?

Thanks,
Mark
 
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
Count Occurances if two conditions true Ed Gregory Excel Worksheet Functions 5 September 8th 05 07:26 PM
Count unique values and create list based on these values vipa2000 Excel Worksheet Functions 7 August 5th 05 01:17 AM
returning a count if two conditions are met davmason Excel Worksheet Functions 5 July 17th 05 04:25 AM
count unique with conditions \ditzman via OfficeKB.com\ Excel Worksheet Functions 8 July 8th 05 12:41 PM
count duplicate (or, inversely, unique) entries, but based on a condition markx Excel Worksheet Functions 3 March 8th 05 06:57 PM


All times are GMT +1. The time now is 02:40 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"