Hi Bob,
I tried entering the example formula but I get an error message.
I was prompted to use the formula construction below

SUMPRODUCT(Array 1,[Array2],[Array3],...)
so I entered
=SUMPRODUCT(A2:A200= --"2005-01-01",[A2:A200,<=
"2005-03-31"],[B2:B200="company_name"],[C2:C200+D2:D200])

I wasn't too sure about the dashes you have included --"2005-01-01"
Can you tell me what they do?

Thought I would post this to let you know where I am at with my problem.
Regards
Dermot
Any other advise regarding my previous posting will be much appreciated.
Thanks
Regards
Dermot

"Bob Phillips" wrote:

=SUMPRODUCT(--(A2:A200=--"2005-01-01"),--(A2:A200<=--"2005-03-31"),--(B2:b2
00="company_name"),(C2:C200+D2:D200))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Dermot" wrote in message
...
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