Ask Your Question
1

Use SUMPRODUCT(ISBLANK()) to count alternated cells range.

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

wlldm 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 close merge delete

Comments

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 +0100 )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 +0100 )edit

1 Answer

Sort by » oldest newest most voted
1

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

Lupp gravatar image

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

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
=SUMPRODUCT(ISODD(ROW(V7:V21));ISBLANK(V7:V21)).
Once again: That's not a solution you should use again and again.

edit flag offensive delete link more

Comments

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 +0100 )edit
Login/Signup to Answer

Question Tools

1 follower

Stats

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

Seen: 127 times

Last updated: Dec 19 '17