Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
Cam Cam is offline
external usenet poster
 
Posts: 165
Default helps with count under multiple condition

Hi,

I need help with count results of column B when it met two criteria in
column A & E.
I am not sure what function to perform. COUNTIF, MATCH etc..



  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,339
Default helps with count under multiple condition

Look at SUMPRODUCT:

=SUMPRODUCT(--(A1:A100=Criteria1),--(E1:E100=Criteria2),(B1:B100))

You can put the criteria in a cell

Note: ranges cannot be whole columns.

HTH

"Cam" wrote:

Hi,

I need help with count results of column B when it met two criteria in
column A & E.
I am not sure what function to perform. COUNTIF, MATCH etc..



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 cells with condition Amanda Excel Worksheet Functions 2 October 13th 07 07:59 PM
count col-A if col-B = condition Balhar Excel Worksheet Functions 8 January 18th 06 10:52 PM
What formula/fn would I use to count multiple condition records? Joshcat99 Excel Worksheet Functions 3 October 27th 05 02:45 AM
Count the occurence of more than one condition wutang1105 Excel Worksheet Functions 1 August 26th 05 08:21 PM
how to count unique entries with multiple condition Michael Excel Worksheet Functions 6 June 29th 05 01:38 PM


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