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 .
Last edited by vamshi57; 12-13-2009 at 10:31 AM.
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
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.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
Thank you . It worked .
Please correct the thread title as requested in post #3.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use the
Always put your code between code tags. [CODE] your code here [/CODE]
“None of us is as good as all of us” - Ray Kroc
“Actually, I *am* a rocket scientist.” - JB (little ones count!)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks