Correction

=SUM(INDIRECT("F3:F"&MAX(MATCH(9.99999999999999E+3 07,F:F))))

--

HTH

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


"GerryK" wrote in message
...
My data set varies in length and would like my SUM IF formula to always
pick
that out. I'd like to eliminate going into the formula and changing the
5000.
There are never any blanks.

I'm using:

=SUM(IF(('Export'!$F$3:$F$5000="Event"),'Export'!$ P$3:$P$5000)). array
entered.

And can find the last used cell,

=MATCH(REPT("z",255),F:F). last used cell in column F

but cannot get correct syntax to merge the two formulae.

Any help greatly appreciated.