Ask Your Question

Use SUMPRODUCT(ISBLANK()) to count alternated cells range. [closed]

asked 2017-12-19 16:10:05 +0200

wlldm gravatar image

updated 2020-07-28 20:53:30 +0200

Alex Kemp gravatar image

Hi, I'm trying to count the blank cells using the formula =SUMPRODUCT(ISBLANK()), but I realized that I can only count consecutive cells like =SUMPRODUCT(ISBLANK(V7:V21)) and what I need is to count alternated blank cells like (V7;V9;V11;V17;V19;V21). Is it possible?

edit retag flag offensive reopen merge delete

Closed for the following reason the question is answered, right answer was accepted by Alex Kemp
close date 2020-07-28 20:53:42.099229


Did you thoroughly consider the tags?
If relying on tahs most users will mainly think of the application names. Thus this topic should first be tagged calc, then (probably) one or two additional tags.

Lupp gravatar imageLupp ( 2017-12-19 16:21:55 +0200 )edit

Didn't know that the tags order influenciate on how people find or understand the topic. But I'll make sure to tag the software name as first one, not the last as I did. Thanks!

wlldm gravatar imagewlldm ( 2017-12-20 19:30:31 +0200 )edit

1 Answer

Sort by » oldest newest most voted

answered 2017-12-19 16:26:49 +0200

Lupp gravatar image

updated 2017-12-19 16:32:41 +0200

Sorry to say: Sheets where formulas have to reference every other row should be redesigned. An example where such a construct is good practice would be interesting to see.
To make provisional repairs you may use
Once again: That's not a solution you should use again and again.

edit flag offensive delete link more


Thanks for your answer! I'll try to reorganize it to make it work using =SUMPRODUCT(ISBLANK()).

wlldm gravatar imagewlldm ( 2017-12-19 16:38:57 +0200 )edit

Question Tools

1 follower


Asked: 2017-12-19 16:10:05 +0200

Seen: 356 times

Last updated: Dec 19 '17