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

Countblank for handpicked cells

I have a complex schedule in a spreadsheet. There are five sheets for the five days of an event. On each day, there are multiple times and rooms being used. And within each day/time/room session, there are multiple roles to be filled.

For each session, I have cells with the positions (e.g., Volunteer) with a cell to the immediate left in which to type someone's name as I recruit volunteers or other roles.

Here is the problem:

I would like to have the spreadsheet automatically count up the empty slots for each of the several types of roles. For example, I would like it do run through the five sheets and count up all the empty cells needing a Volunteer.

I understand that you can use CountBlank for a column, row, or box of cells. But, that won't work for me.

Is there a way to handpick specific cells and name them something like "VolunteerSlots" and then run CountBlank using that as the range? Like, could I ever use something like this: =Countblank(VolunteerSlots)? That would ideally then count the handpicked cells to see if they are empty or not.

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

Want to read more?

Check out the full article on the original site

View original article

Tagged with

#Excel alternatives for data analysis
#natural language processing for spreadsheets
#generative AI for data analysis
#modern spreadsheet innovations
#machine learning in spreadsheet applications
#enterprise-level spreadsheet solutions
#digital transformation in spreadsheet software
#google sheets
#collaborative spreadsheet tools
#AI-driven spreadsheet solutions
#cloud-based spreadsheet applications
#financial modeling with spreadsheets
#automation in spreadsheet workflows
#no-code spreadsheet solutions
#AI-powered spreadsheet
#spreadsheet API integration
#rows.com
#Excel compatibility
#row zero
#real-time data collaboration