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 ?????

sumif()

On Sat, 9 Apr 2005 02:31:03 -0700, SteveMcDowell19
wrote:

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

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


In article ,
SteveMcDowell19 wrote:

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 ?????