Do you realize that you have just posted Bob's e-mail address on the web?

Why do you think that we disguise our addresses?
So that we love to get TONS of spam?

IMHO, you have done him a *GREAT* disservice ! ! !
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Dermot" wrote in message
...
Hi Bob
I sent an email to your email address not sure if you accept emails from newsgroup posters?
I attached my excel attempt to understand SUMPRODUCT....but I haven't
managed to get it to work for me yet.
Would you be able to send me a working example as discussed in this
posting?
Thanks
Dermot


"Dermot" wrote:

I have a spread sheet with for simplicity 4 columns
Column 1 is a Date Column,
Column 2 is a Company Name,
Column 3 is a Payment amount X
Column 4 is a Payment amount Y

The amount due is the sum of X+Y between the relevant dates.

The entries are in date order and the Company names random.
The number of entries per company varies also.
I want to be able to calculate the amount due for each company over a
thee
month period between certain varied dates.

Questions
1. Is there a way to enter the dates to calculate between.
2. What is the best way to perform the calculations for each company?

An example or link to an example would be appreciated.
Regards
Dermot