# SUMIF not working

#### infuse

##### Board Regular
HI all:

Can i know why this equation is not working?
Code:
``=SUMIF(A1:A31,( ">23")*("<6"),\$B\$1:\$B\$31)``

I would like to sum column B if Column A is greater than 23 and less than 6.
The greatest number in Column A is 24 (It is 24 hours time).
I know the problem is with
Code:
``( ">23")*("<6")``
What i would like to know is what is wrong with it.

Thanks in advance for the help

### Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off
sumif doesn't allow two criteria. Does this get what you need?
=SUMIF(A1:A31,">23",\$B\$1:\$B\$31)+SUMIF(A1:A31,"<6",\$B\$1:\$B\$31)

SUMIF(A1:A5,AND(A1>23,A1<6),A1:A5)

of course change the columns to the appropriate column...but you need the AND in there.

Yes, that worked like a charm...

THanks.
Infuse

Wally-sns:
No, your formula does not work. Anways thanks for your time..Appreciate it

Mine ? or the other post ?

just curious if it worked out.

Replies
8
Views
238
Replies
6
Views
255
Replies
2
Views
186
Replies
6
Views
243
Replies
1
Views
204

1,219,970
Messages
6,151,211
Members
451,017
Latest member
peterlam84

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