•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
#AI formula generation techniques
#Excel alternatives for data analysis
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#natural language processing for spreadsheets
#generative AI for data analysis
#Excel compatibility
#SUMPRODUCT
#spreadsheet
#ISTEXT
#FORMULATEXT