1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

Issue with sum count in mirrored spreadsheet?

Hi, I've been trying to deal with a thing to count completion for two-mod combos in a game my friends and I play. It's supposed to be mirrored, and it's worked until I expanded the sheet by three rows and columns. I have the following formulas to count the cells that have text that isn't a formula

=SUMPRODUCT( --ISTEXT(B2:CD82), --IFERROR(FORMULATEXT(B2:CD82)="", TRUE) )

and the following to count everything that doesn't have a formula

=SUMPRODUCT( --(B2:CD82<>""), --IFERROR(FORMULATEXT(B2:CD82)="", TRUE) )

But it's not working, it's just saying both are 0. What am I doing wrong? Here's an image of the spreadsheet, sans the calculated part: https://imgur.com/a/SJ4qZEd

submitted by /u/CharlieTheAnon
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#rows.com