=SUM(IF(('Sales&Income'!$G$10:$G$24<"")*('Sales&I ncome'!$A$10:$A$24=$D$2)*('Sales&Income'!A10:A24< =$G$2),('Sales&Income'!$G$10:$G$24)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
---
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Vibeke" wrote in message
...
This should be simple, but it's defeating me.

Column A is a date, Column C is text, Column F is a number, and column G
is
=IF(C10="Sales",F10/9,"")

In a separate worksheet, a SUMPRODUCT formula works fine to add up the
values in Column F where they fall between two dates (entered in D2 and
G2),
i.e:

=SUMPRODUCT(--('Sales&Income'!$F$10:$F$24),--('Sales&Income'!$A$10:$A$24=($D$2)),--('Sales&Income'!A10:A24<=($G$2)))

I also want to sum the aforementioned Column G for the same date
parameters,
but
=SUMPRODUCT(--('Sales&Income'!$G$10:$G$24),--('Sales&Income'!$A$10:$A$24=($D$2)),--('Sales&Income'!A10:A24<=($G$2)))
returns #VALUE!

I suspect it is doing this because it doesn't like the 'value if false'
result ("") of the =IF(C10="Sales",F10/9,"") formula. Is there a way to
get
around it?

Many thanks!