Need Function

[Guest]

I'm new to Excel and need a function that will sum an array if the total is
between 70 and 72.

=SUM(B5:H5)=>70,<=72 ?????

 

[cola]

sumif()

 

[Ron Rosenfeld]

I'm new to Excel and need a function that will sum an array if the total is
between 70 and 72.

=SUM(B5:H5)=>70,<=72 ?????

=IF(AND(SUM(B5:H5)>=70,SUM(B5:H5)<=72),SUM(B5:H5),"out of range")


--ron

 

[JE McGimpsey]

One way:

=SUMIF(B5:H5,">=70")-SUMIF(B5:H5,">75")

or, equivalently

=SUMIF(B5:H5, "<=75")-SUMIF(B5:H5,"<70")

Alternatively:

=SUMPRODUCT(--(B5:H5>=70),--(B5:H5<=75))


For an explanation of the "--", see

http://www.mcgimpsey.com/excel/doubleneg.html