# Count the totals from each cell

#### Brew

##### Well-known Member
How do I create a formula to count the total results from each of the following cells:
E24,42,60,78,96,114,132,150,168,186,204,222,240,258,276,294,312,330,348,366,384,402,420,438

### Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().
Try:

=SUMPRODUCT((MOD(ROW(E24:E438)-ROW(E24),18)=0)*(E24:E438)) to sum the entries...

if you want to actually count how many have entries, then try:

=COUNT(IF((MOD(ROW(E24:E438)-ROW(E24),18)=0)*(E24:E438),1)) confirmed with CTRL+SHIFT+ENTER not just ENTER

I think the first formula will work, however, I have the cell format for my cells set to 0;-0;;@ so, if the result is 0 for all enteries, i need for my result to be blank. It now returns a #value result for that condition. So do I update the cell format where I place the formula or update the formula

All values in the range E24:E438 must be numeric or you will get a #Value error...

Try: =SUM(IF(ISNUMBER(E24:E438),IF((MOD(ROW(E24:E438)-ROW(E24),18)=0)*(E24:E438),E24:E438)))

confirmed with Ctrl+Shift+Enter not just Enter.

Cool that works Great!

Replies
8
Views
213
Replies
1
Views
181
Replies
0
Views
172
Replies
5
Views
148
Replies
2
Views
128

1,219,800
Messages
6,150,322
Members
450,951
Latest member
kh198

### 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.
Allow Ads at MrExcel

### Which adblocker are you using?

Follow these easy steps to disable AdBlock

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

### Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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