Count Occurrences using multiple criteria

Hi,

The formula I have used this time is:

Formula:

Please Login or Register  to view this content.

The first SUMPRODUCT counts the number of listings that are no longer active and that were active during the period specified in the relevant zip code, and the second SUMPRODUCT counts the number of listings that are still active and were active during the period specified in the relevant zip code. The named range MonthNames is the range O4:O15 where you had discreetly specified the month names for the drop-down boxes B2 and B3 of the Report worksheet :P

I hope this is what you are looking for again

Wow.... Thats it! Thank you once again. Do you have any recommendations for tutorials on SUMPRODUCT? I really appreciate all your help.

No problems!

Umm, probably just keep reading forums like this one, and the Office Help can also be of use, but doesn't go into using SUMPRODUCT for arrays such as what I've done here, but it still isn't a bad place to start. You'll find that you will pick it up pretty quickly once you start using it more and more often.

I started my current job 2 years ago, with minimal knowledge of Excel and absolutely no knowledge of VBA, and now I'm the office go-to guy for all things Excel and VBA. I learnt what I know now simply by reading forums to pick up hints and tricks, and then by applying those tricks over and over again until they stuck, and I've even developed a few of my own little tricks as a result.

Anywhoo, I hope this helps you learn what you want to learn

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks

Originally Posted by Tony Valko

Here ya go:

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

Thank You!