I have a very long column of zeros and ones. I need to use excel to tell me how many #1's in a group of 7 cells in a row. Is there any function I can use to have this calculated?
I have a very long column of zeros and ones. I need to use excel to tell me how many #1's in a group of 7 cells in a row. Is there any function I can use to have this calculated?
Is this a Google Sheets query?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
UPDATE: RAN INTO ANOTHER PROBLEM ACTUALLY: SEE MY REPLY BELOW
No it's actually for Office Libre, but it has all of the functionality as the Full Excel. And now I magically came across how to count duplicates
I think this works for me actually
Last edited by Salmonbushes; 12-30-2020 at 09:24 AM.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Actually, just ran into something else about this. Basically I need to add an exception to the formula which is =IF(I2=I1,J1+1,1) so that this formula won't run for each cell in column "I" having the value of 0. Do you know what I would add to this formula to achieve that?
Do you mean this?
=IF(I2=0,"",IF(I2=I1,J1+1,1))
YES! That's perfect Thanks! I'll mark this thread as "solved"
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks