Roger does indeed speak for me ... you are very welcome. Thanks for letting
us know that we were able to help.

I generally use "Show Replies to my Messages" to track posts that I have
replied to so I would see your response ... but thanks for the belt and
braces.

Regards

Trevor


"RS" wrote in message
...
Dear Roger & Trevor,

I replied in the original thread also but I'll post here just in case
you don't look at the original thread. Thanks to both of you for all your
help!

"Roger Govier" wrote:

Hi

In case you cannot see it for some reason, Trevor answered you question
as

Something like:

=SUMPRODUCT(($J$49:$J$73=DATE(2006,7,1))*($J$49: $J$73<=DATE(2007,6,30))*(MONTH($J$49:$J$73)=7)*($ K$49:$K$73=$AC14))

Regards

Trevor

With regard to extending to additional rows of data as they are added,
you would need to use Dynamic named ranges as the range for your data
sets.

Once again, you will find excellent instruction on this at Debra
Dalgleish's site
http://www.contextures.com/xlNames01.html#Dynamic


--
Regards

Roger Govier


"RS" wrote in message
...
Dear Trevor,

This is unrelated to this post but I don't know how else to get in
touch with you. I had posted a question in the Excel forums yesterday
regarding "How do I count frequency based on 2 criteria (including
month)."
You helped answer part of my question but I had posted another
question to
you in the same post. If you could please look at the thread and post
your
answer that would be great. The thread url is:

http://www.microsoft.com/office/comm...f-f6f7d2f3b9b3

Thanks again for your assistance.

"Trevor Shuttleworth" wrote:

A1:
=IF(AND(B1="Grocery",C1="MT"),"William",IF(AND(B1= "D&F",C1="RM"),"Ronald","")

Regards

Trevor


"AMBO" wrote in message
...
I want to yield in the 1st cell "William" when I choose "Grocery" in
another
cell and "MT" in the other. And 2nd cell "Ronald" when I choose
"D&F" in
another cell and "RM" in the other.

How do I write the IF and AND function for the situation mentioned
above?