ExcelBanter - Need Function

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Need Function (https://www.excelbanter.com/excel-worksheet-functions/21275-need-function.html)

SteveMcDowell19

Need Function

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

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

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

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

All times are GMT +1. The time now is 11:23 PM.