SUMIF

Avner Mediouni · Aug 14, 2003

I would like to know if it is possible to use SUMIF function to sum number
that are BETWEEN two condition
(i.e. =SUMIF(A1:A10,">3 & <10",B1:B10)

Sincerely yours
Avner Mediouni
R&D Physicist
e-mail: (e-mail address removed)

Leo Heuser · Aug 14, 2003

Avner

One way:

=SUMPRODUCT((A1:A10>3)*(A1:A10<10)*B1:B10)

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

Avner Mediouni · Aug 17, 2003

Dear Mr Heuser,
Thank you very much.

Leo Heuser · Aug 17, 2003

You're welcome, Avner.
We like to be on first names in the groups :-)

It's more relaxed.

LeoH