**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.*