Formula assistance please???
Maybe
=SUMIF(Sheet2!A1:A19,"500000")-SUMIF(Sheet2!A1:A19,"=1500000")
Mike
"Kimmie_C" wrote:
Friends,
I'm looking for a formula to use in Excel 2003. I need to sum the figures
that are greater than 500k but less than 1.5M in a data range in another
sheet. Can anyone help? need quickly please...
--
Kimmie_C
|