greater than/less than problem

jjf

New Member
Joined
Sep 18, 2006
Messages
3
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)
 

Some videos you may like

Excel Facts

Waterfall charts in Excel?
Office 365 customers have access to Waterfall charts since late 2016. They were added to Excel 2019.

Aladin Akyurek

MrExcel MVP
Joined
Feb 14, 2002
Messages
85,201
Because not well-formed... Try:

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

Confirmed with control+shift+enter.
 

Watch MrExcel Video

Forum statistics

Threads
1,111,910
Messages
5,541,541
Members
410,547
Latest member
htran4
Top