More on SumProduct

[theillknight]

=SUMPRODUCT(('OTHERSHEET'!E$2:E$65536=$B$1)*('OTHERSHEET'!R$2:R$65536=E10)*('OTHERSHEET'!G$2:G$65536))

I have the above formula and it works... to an extent. Column R i
'OTHERSHEET' is the pool of dates from which I want to use Sumproduct.
E10 in the active sheet is the actual date I'm searching for. Right no
it pulls the information from exactly that date - but sometimes I migh
want the information for greater or less than that specified date.

Does anyone know of a way I can do this?

I know one method is to change:

'OTHERSHEET'!R$2:R$65536=E10)

to:

'OTHERSHEET'!R$2:R$65536>E10)

but I'd rather only change the date field and not the formula eac
time, because I don't know if I want information on the date, before
or after.

Any help would be greatly appreciated

 

[duane]

maybe set up a cell to use as flag so if cell XX=1 you get >, if cell X
=2 you get <, els you get =