SUMIF help

[WahooCPA]

I have data similar to this

115
115
121
125
131
135

If the number is less than 120 include cell contents in sum
If the number is greater than 120 and less than 130 include the value of 120 in the sum
If the number is greater than 130 do not include in sum

Thus the result i am looking for would be 470.

How can I sum this way?


Thank you in advance.

[FDibbins]

Hi, welcome to the forum

Try this...
=SUMIF($A$1:$A$6,"<120")+120*COUNTIFS($A$1:$A$6,">=120",$A$1:$A$6,"<=130")

All of your rules say greater than or less than, none said =, so I took it to be >=120 and <=130...adjust this as needed

[ChemistB]

Try

=SUMIF(A1:A6,"<120",A1:A6)+120*(COUNTIFS($A$1:$A$6,">=120",$A$1:$A$6,"<=130"))

Dang, too slow again. LOL

[WahooCPA]

Thank you for the help, that did exactly what I needed.

[FDibbins]

Happy to help

(Chemist, you reminded me of that "like a good neighbour" insurance commercial with the girl and the guy with the fishing pole...you gotta be quicker than that)