Question description:
This user has given permission to use the problem statement for this
blog.
Formula help: =COUNTBLANK(offset(Inglewood!C$2,,MATCH(D3,Inglewood!$C$1:$N$1,0)-1,counta(Inglewood!$A:$A)-1))
This is helping me have conditional formatting based on empty cells from another tab. I want to change the range of data that is being seen. (i.e. instead of C2:C47 I want it to be C11:C47)
Solved by V. U. in 31 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
04/09/2018 - 09:11
https://docs.google.com/spreadsheets/d/1rkbMwgyeP8njR1EyBP4xT4xji7qZIIO8se7K901T7rg/edit#gid=2066707352
User
04/09/2018 - 09:11
I can grant access once you request it
Excelchat Expert
04/09/2018 - 09:12
Welcome, Thanks for choosing Got It Pro-Excel.
User
04/09/2018 - 09:13
Thanks, I just want to update a formula in the google sheet (link I just sent)
User
04/09/2018 - 09:13
Just not sure best way to do it
Excelchat Expert
04/09/2018 - 09:14
Okay.
Excelchat Expert
04/09/2018 - 09:14
I can't see the file.
User
04/09/2018 - 09:14
Request access and I have it open to grant immediately
Excelchat Expert
04/09/2018 - 09:14
I have requested access.
User
04/09/2018 - 09:14
Just approved
User
04/09/2018 - 09:15
So in the School Summary tab - Column E is the formula
User
04/09/2018 - 09:16
So for Inglewood, I just want the items from Row 11 to Row 47 to be considered instead of the entire column
Excelchat Expert
04/09/2018 - 09:18
Following through the data...
Excelchat Expert
04/09/2018 - 09:20
Okay.
Excelchat Expert
04/09/2018 - 09:21
What exactly do you want the formula to accomplish?
User
04/09/2018 - 09:21
I want it to collect the number of empty cells in the 'district' tab (i.e. Inglewood, LAUSD, Lawndale, etc.) for each individual school from C11:C47
User
04/09/2018 - 09:22
It's currently pulling C2:C47
Excelchat Expert
04/09/2018 - 09:27
I have changed the range.
Excelchat Expert
04/09/2018 - 09:27
=COUNTBLANK(OFFSET(Inglewood!C$2,,MATCH(D3,Inglewood!$C$1:$N$1,0)-1,COUNTA(Inglewood!$A$11:$A$47)-1))
User
04/09/2018 - 09:29
Yeah I see that, but when I test it (tab Inglewood) it's not accurate
Excelchat Expert
04/09/2018 - 09:29
Okay. Let me check the formula.
User
04/09/2018 - 09:29
Celll 11 through 47 says TEST in it with blanks at the top but it's still showing as 4 empty cells
Excelchat Expert
04/09/2018 - 09:33
I am formulating the formula again...
Excelchat Expert
04/09/2018 - 09:33
Please give me sometime...
User
04/09/2018 - 09:33
Thanks for update
Excelchat Expert
04/09/2018 - 09:39
Thank you for your patience.
Excelchat Expert
04/09/2018 - 09:39
The CORRECT formula is:
Excelchat Expert
04/09/2018 - 09:39
=COUNTBLANK(OFFSET(Inglewood!$B$11,0,MATCH(D3,Inglewood!$C$1:$N$1,0),ROWS($A$11:$A$47),1))
Excelchat Expert
04/09/2018 - 09:41
It returns 28 blank cells in the range A11:A47
User
04/09/2018 - 09:42
yeah it does!! great thank you!!
Excelchat Expert
04/09/2018 - 09:42
Is there any question or clarification you may need?
User
04/09/2018 - 09:43
Nope, thank you again!
Excelchat Expert
04/09/2018 - 09:43
It was my pleasure helping you solve this problem. Any time you have a problem with Excel do not hesitate to come back for help.
Excelchat Expert
04/09/2018 - 09:43
Please remember to rate us at the end of the chat for better and quality services. Thank you!
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
