Counting by categories and dates

[vamshi57]

I have email dump in one sheet which has daily emails tracked and have status " Reffered , Closed , Open-Idle " . Now in the summary sheet I want a formula which returns the count of reffered , closed from " email dump" sheet . I guess lookup & countif kind of fuctions should return what I need .. not sure how to put together .

I can do a pivot to get this but I don't want too as the file size should be very small for me .

[JBeaucaire]

Put this formula in C3 and copy it down across the chart:

=SUMPRODUCT(--('Email Dump'!$D$2:$D$30=C$2),--('Email Dump'!$G$2:$G$30=$B3))

Be sure to adjust the ranges searched equally when you do it.

[JBeaucaire]

NOTE:

Your title for this thread actually breaks the forum rules...instead of summarizing your need, you made a "guess" at the answer.

People use the forum to search out their own solutions to issues, and your title makes this thread a total bust for them. It won't help someone searching for LOOKUP or COUNTIF since that's not needed for your problem, not part of the answer.

If you would, EDIT that original post and use a descriptive title, like "Counting by categories and dates" or "Counting by multiple criteria". You might have to click GO ADVANCED, I can't remember for sure.

Thanks.

[vamshi57]

Thank you . It worked .

[JBeaucaire]

Please correct the thread title as requested in post #3.