•1 min read•from 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
[link] [comments]
Want to read more?
Check out the full article on the original site
Tagged with
#rows.com