# greater than/less than problem

#### jjf

##### New Member
Thanks so much for your help earlier. I ran into another problem.
Why is my sumif statement including numbers higher than 92.4?
Once again, any help would be greatly appreciated.

=SUM(IF(A3:A62<92.4>84.5,C3:G62)

### Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)
Because not well-formed... Try:

=SUM(IF(A3:A62 > 85.5, IF(A3:A62 < 92.4, C3:G62)

Confirmed with control+shift+enter.

Replies
3
Views
241
Replies
3
Views
340
Replies
0
Views
838
Replies
19
Views
1K
Replies
0
Views
622

1,218,909
Messages
6,145,167
Members
450,592
Latest member
Boulder127

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back