How do I add multiple conditions to a formula?
=SUMPRODUCT((A1:A5="control")*(B1:B5=0.3)*(B1:B5< =0.4))
Jerry
"multiple conditions formula" wrote:
Hi, I've tried using COUNT, SUM, SUMIF, COUNTIF, SUMPRODUCT, and nesting IF
functions, but I can't seem to get this formula to work.
control 0.122
GlcNAc 0.255
GlcNAc 0.478
control 0.377
control 0.301
I want to count the number of values for "control" between 0.3 and 0.4, and
have this count represented in a cell on a separate worksheet. Thanks a lot
for all your help.
|