Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 6
Default how to use multiple criteria with countif function in excel

Please, give the solution within 10 min, if possible
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default how to use multiple criteria with countif function in excel

Use a Helper column to combine the criteria into a single cell.
--
Gary''s Student - gsnu200724
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 10,124
Default how to use multiple criteria with countif function in excel

SUMPRODUCT

--
Don Guillett
SalesAid Software

"Debu" wrote in message
...
Please, give the solution within 10 min, if possible


  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,058
Default how to use multiple criteria with countif function in excel

Good addition.

Also the difference in two COUNTIF functions to test greater than one
criteria and less than the other.
--
Gary''s Student - gsnu200724


"Don Guillett" wrote:

SUMPRODUCT

--
Don Guillett
SalesAid Software

"Debu" wrote in message
...
Please, give the solution within 10 min, if possible



  #5   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,391
Default how to use multiple criteria with countif function in excel

I was going to say "Use DCOUNT", but I'm obviously too late.

NickHK

"Debu" wrote in message
...
Please, give the solution within 10 min, if possible





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
Countif Function w/ multiple Criteria LaTanya Excel Worksheet Functions 2 November 13th 08 09:42 PM
COUNTIF or SUM function (Multiple criteria) HELP!! Australia Excel Worksheet Functions 3 September 19th 05 07:39 AM
countif function with multiple criteria Geoff Excel Discussion (Misc queries) 1 August 11th 05 11:50 PM
EXCEL multiple criteria in countif function tvbrower Excel Programming 3 July 16th 04 07:56 PM
EXCEL multiple criteria in countif function Robert[_22_] Excel Programming 10 June 17th 04 03:18 PM


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