sum cells in an excel column that fall between cells that fit a specific criteria?

Laura Garnham · 2018-09-26T15:19:29+01:00

Hi, I have an excel column that consists of a 1s or 0s like so: 1 1 1 0 1 1 1 1 0 0 1 0 0 0 0 0 0 1 1 1 1 1. I would like to be able to count how many 1s there are after there are 2 consecutive 1s and before 6 consecutive 0s (so in this case I would get a result of 6). I have to do this for about 200 columns so a formula that automatically does this would be really useful. Please can you tell me if it possible to do this, and, if so, how? Thanks very much for your help.

Carim

OzMVP (0007*2) - 4

Reactions Received

916

Points

36,086

Posts

6,994
Oct 9th 2018
- #21
Hello Laura,

Are you familiar at all with Array Formulas ?

Just in case ... https://www.excel-easy.com/functions/array-formulas.html
If you feel like saying "Thank You" for the help received, do not hesitate to click the "Thumbs Up" icon, below, in the bottom right corner
Quote
- 1
- 2Page 2 of 2

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Navigation
OzGrid
Forum
1. Unresolved Threads
2. Forum Rules
Dashboard
Articles
Privacy Policy
Search
Options
Current Location
OzGrid Free Excel/VBA Help Forum
Forum
HELP FORUMS
Excel Formulas

User Menu
Login or register

This site uses cookies. By continuing to browse this site, you are agreeing to our use of cookies. More Details Close

Your browser has JavaScript disabled. If you would like to use all features of this site, it is mandatory to enable JavaScript.

Participate now!

Share