LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 56
Default How to get result by using CountIF, if there are 3 conditions to b

If you have Excel 2007 it's quite simple, just use CountIFS instead of
CountIF, I think you can have up to 56 conditions, so it's really quite a
powerfull function. CountIFS and SumIFS are functions not available in Excel
2003.
I really love them both.

Regards
farid2001



"Subbu" wrote:

How to get result by using CountIF, if there are 3 conditions to be met? I
want to get the number of occurances with 3 or more conditions to be checked!
Please help

Thanking you



 
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 Conditions - Use of conditions that vary by cell value JonTarg Excel Discussion (Misc queries) 1 May 30th 08 01:21 PM
return a result from multiple conditions. Christy Excel Worksheet Functions 4 July 9th 07 09:26 PM
how to return a result from 2 conditions? Christy Excel Worksheet Functions 2 July 9th 07 04:42 PM
How do I set up multiple logical conditions on one result cell Ring eye Excel Worksheet Functions 1 January 12th 06 07:31 PM
2 Conditions True, Many Variables, Return Result elliekev26 Excel Worksheet Functions 4 September 22nd 05 04:16 PM


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