# sumif question

#### Jinjunwei

##### New Member
I think this is an easy question for someone.. even though I couldnt find anything on google or excel help. Is there a way to use sumif together with real numbers? For example, I have 3 rows of data like this:

5
#value
2

I want to sum the column... and just count numbers. Is there a way to do this? (without starting another column and using an if statement)?

Brian

### Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.
Aladin's post here is one way. Hope that helps!

Thanks!

Hi jinjunwei:

Also ...
Book1
ABCD
15
2#VALUE!7
32
4
Sheet4

thanks Yogi

You Are Very Welcome Jinjunwei ... now let us keep EXCELing!

Replies
7
Views
508
Replies
2
Views
243
Replies
4
Views
388
Replies
5
Views
710
Replies
20
Views
1K

1,214,256
Messages
6,118,521
Members
448,830
Latest member
Drew Terp

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