On Tue, 30 Dec 2008 07:01:01 -0800, Confused of Chingford! <Confused
of wrote:

Hi

I have been attempting to resolve this issue for a while, having looked both
here and at MediaKent.co.uk
My issue is that i have a worksheet containing financial data in the
following format
Column A = Nominal ledger Code (format nnnn)
Column B = Department Code (format n)
Column C = Transaction Date (format nnnnn)
Column D = Transaction Value (format NNNNN.NN)

I have tried several SumProduct statements, and have overcome the date issue
by creating a seperate spreadsheet with the months converted to a general
format as the sumproduct didnt seem to like the column being set with a mmyy
format.

I need to pull values for particular nominal ledger codes, department
numbers, falling within a date range into a seperate sheet.

I am using the following formula
=SUMPRODUCT((Sheet1!D1:D16201)*(Sheet1!A1:A16201= "4000")*(Sheet1!B1:B16201=1)*(Sheet1!E1:E16201=Sh eet2!B1)*(Sheet1!E1:E16201<=Sheet2!B2))*-1

Where 4000 = nominal code, 1 = department number, and sheet 2 b1 and b2 hold
the upper and lower numerical values for the date range.

Once i have fathomed this bit out i will need to add additional criteria as
some of the cells will hold the values of multiple nominal codes, and to
ensure that future data that is pulled via ODBC from a sage accounting system
i will need to include currently empty cells in the calculations.

Any help greatly appreciated and will also prevent me from going premeturely
bald!!!

You forgot to mention what the problem is with the formula you use.
Does it return the wrong value or does it return an error?
What value do you expect an what do you get.
Why do you use " with the Nominal ledger code ("4000") but not with
the Department code (1)?

Lars-Åke