SUMIF
 

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:

SUMIF
 

Avner

One way:

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

--
Best Regards
Leo Heuser
MVP Excel

Followup to newsgroup only please.

"Avner Mediouni" skrev i en meddelelse
...
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:

SUMIF
 

Dear Mr Heuser,
Thank you very much.





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

SUMIF
 

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

LeoH

"Avner Mediouni" skrev i en meddelelse
...
Dear Mr Heuser,
Thank you very much.





*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!