I thought providing a solution to all of my readers on this issue might be warranted, though. Now, this reader reached out a couple of times, but I was never able to get him a solution (I had some clarifying questions.) before he went silent on me. ![]() Basically he wants the formula only to work on rows that are visible. He (or she.I'll use "he" throughout for simplicity) wanted help transforming a SUMPRODUCT formula that he currently uses to be useful in situations where the data is filtered or for some other reason certain rows are hidden. ![]() The other day a reader contacted me through my MeeboMe chat window.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |