Hi,
I have a column of data and I want to check every 3rd cell i.e. A3, A6, A9 etc to see if they are blank and then return the number of blank cells. I do not care if A4, A5, A7, A8 is blank.
Any help would be greatly appreciated!
Hi,
I have a column of data and I want to check every 3rd cell i.e. A3, A6, A9 etc to see if they are blank and then return the number of blank cells. I do not care if A4, A5, A7, A8 is blank.
Any help would be greatly appreciated!
Last edited by Baccawastaken; 07-28-2021 at 05:47 PM.
Try this non Array formula
Array formulaHTML Code:
HTML Code:
Last edited by wk9128; 07-28-2021 at 08:46 AM.
While having a location of Mars and a version of "Nunya" might be cute, it is important to know that information in order to give you a good answer. Local may alter a formula, and depending on what version you have, some formulas may not work. Please supply this info so we can better answer your question.
The sum of the blank cells will be zero, so what’s the point? Or did you not state your requirements correctly?
Administrative Note:
Welcome to the forum.
Although we value your privacy as much you do, it could be important that members have a rough idea of your location as the solutions they offer may be affected by your locale. For instance, you might in the future post questions which are related to your regional settings.
With this in mind, please update your profile to something more precise (something such as UK, Europe, USA, UAE, etc. will suffice).
Also update your MS Office version, as this will affect potential solutions offered.
Thank you for helping us to help you.
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.
I've updated my details but have found the solution myself.
Please share your solution. Another with the same question may find it helpful.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
Also, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
Dave
A way is =SUMPRODUCT((A1:A12="")*(MOD(ROW(A1:A12),3)=0))
but your solution would be interesting
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks