PDA

View Full Version : CounIFS with Month Criteria



surya prakash
01-13-2008, 10:54 PM
Hi,
I am wondering if it is possible to count the number of occurances of "Closed" status that fall in a month (say Jan'07 or Feb'08) using CountIFS function....

Sample Excel File is enclosed...

Will be thankful for any feedback...

anandbohra
01-14-2008, 03:55 AM
Hi

Countifs function is included in Excel-07
but the same can be customized in Excel 03 with the help of Sumproduct function.

best webpage to learn about Sumproduct is

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Pl see the attached file with the output as u desired.
Custimized the same with Sumproduct as told earlier

anandbohra
01-14-2008, 04:05 AM
Another best way is use of Pivot Tables

see attachment

surya prakash
01-15-2008, 01:58 AM
Thanks a ton Anand; will check and revert back....