Need to sum characters in multiple cells, same column, different rows

**Jamie78** · 02-15-2012, 03:02 PM

I have been looking online, but to no avail. Basically I need to sum the number of forward slashes (/) within multiple cells that are not adjacent, ie J7, J9, J11, J13 and on for 20 or so cells. Is there any way to do this without a macro?

Thanks!

**daddylonglegs** · 02-15-2012, 03:06 PM

Hello Jamie78,

You can use this formula to count all forward slashes in alternate cells from J7 onwards, as far as J47, adjust as required

=SUMPRODUCT((MOD(ROW(J7:J47)-ROW(J7),2)=0)+0,LEN(J7:J47)-LEN(SUBSTITUTE(J7:J47,"/","")))

**Winon** · 02-15-2012, 03:16 PM

@dll,

Impressive! Is there an end to what you can come up with?

**Jamie78** · 02-17-2012, 10:16 PM

Thank you so much. I'll try it as soon as I get into the office on Monday. Is it an array formula? I just started learning about those so I'm sorry if I'm asking an obvious question. Again, thank you!