How do I link it to the spreadsheet with the data. The one I am putting the
formula in is a 'Comparisons' as it pulls data from different sources, but
the data is in 'New Revenue', etc
Thanks.

"Frank Kabel" wrote:

Hi
if the month value is not a date but a text value try:
=SUMPRODUCT(--(A1:A100="Apr 04"),--(C1:C100="New"),E1:E100)

Also see:
http://www.xldynamic.com/source/xld.SUMPRODUCT.html

--
Regards
Frank Kabel
Frankfurt, Germany

"harwookf" schrieb im Newsbeitrag
...
Hi. Can anybody help me with a formula based on two conditions.

I have a spreadsheet with various columns (example shown below).

Month Customer Contract Type Contract Value Yr Value
Apr 04 xxx New £10,000 £2,000
Apr 04 xxx Upgrade £2,000 £500
May 04 xxx New £15,000 £5,000

I need to be able to total the 'Yr Value' for 'New' contracts in 'Apr
04'.
In the example above, I expect to get £2,000 for Apr 04 and £5,000
for May 04.
This could be more complicated as the spreadsheet I want to put the
formula
in is different from where the information is.

I have tried various formula with no success. Below is an example of
one
that I have tried.

=SUM(IF(('[New Revenue 04_05.xls]New Revenue'!$A$2:$A$300="Apr
04")*('[New
Revenue 04_05.xls]New Revenue'!$D$2:$D$300="New"),'[New Revenue
04_05.xls]New
Revenue'!$K$2:$K$300))

Thanks.