Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 06, 02:37 AM 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

  #3   Report Post  
Old January 31st 06, 04:57 AM posted to microsoft.public.excel.newusers
Max
 
Posts: n/a
Default How do I count based on two conditions?

Another option is to use SUMPRODUCT ..

Assuming source table is within A1:B100,
data from row2 down

Placed
In D2 down: Big Corp, Small Corp, etc (i.e. company names)
In E1: operational
In F1: non-operational

(Ensure the names / words match exactly with those within the source table.
Check spelling and spaces, etc.)

Then we could put in E2:
=SUMPRODUCT(($A$2:$A$100=$D2)*($B$2:$B$100=E$1))
Copy E2 to F2, and fill down to populate the table

Note that we can't use entire col references (eg: A:A, B:B, etc) in
SUMPRODUCT
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Mark G" <Mark wrote in message
...
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





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
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 07:57 PM


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

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017