SUM IF BLANK for just cells D6,D8,D10,D16,D18,D20,D22

[jpkreider]

I'm getting an error that says you've entered too many arguments for this function. Please help!!??

Here's what I used: =SUM(IF(ISBLANK(D6,D8,D10,D16,D18,D20,D22)))

 

[Jonmo1]

That type of function will only work on a contiguous range.

It's difficult to tell exactly what you intended with that formula..
Which cells were you testing for Blank, and which were being summed based on those tests ?

What is in the between cells (D7 D9 D11 etc.) ?

 

[Joe4]

Are you just trying to count how many of your listed cells are blank?

 

[Aladin Akyurek]

I'm getting an error that says you've entered too many arguments for this function. Please help!!??

Here's what I used: =SUM(IF(ISBLANK(D6,D8,D10,D16,D18,D20,D22)))

Are you wanting to count the cells that are blank or empty?

 

[jpkreider]

Wouldn't that function just be COUNTBLANK? I'm trying to could the blank or empty cells from a selection of cells, not contiguous. The cells in-between are where I enter overtime hours. This formula will count how many people were on staff. If they call in sick or have vacation, I will enter "D" into the cell, so I don't want my formula to count that cell as "blank"

 

[jpkreider]

Yeah, I just want to count the blank or empty cells.

 

[Jonmo1]

Do you have any kind of 'key' in another column, like C.
So we can say only count blank cells in D, if the cell in C reads "Staff Name" or something?

 

[Aladin Akyurek]

Yeah, I just want to count the blank or empty cells.

Control+shift+enter, not just enter:

=SUM(IF(CHOOSE({1,2,3,4,5,6,7},D6,D8,D10,D16,D18,D20,D22)=0,1))

Does this help?

By the way, if it does, you'll need to adjust the first argument of CHOOSE, which is set to 7 for you have 7 non-contiguous cells.

 

[jpkreider]

Control+shift+enter, not just enter:

=SUM(IF(CHOOSE({1,2,3,4,5,6,7},D6,D8,D10,D16,D18,D20,D22)=0,1))

Does this help?

By the way, if it does, you'll need to adjust the first argument of CHOOSE, which is set to 7 for you have 7 non-contiguous cells.

It's closer. At least the formula works. Unfortunately, the answer it give me is "1" when all 7 cells are empty. I was hoping for an answer of 7 because they are all empty and 6 if there is a "D" in one of the cells. I hope this makes sense and apologize for the confusion.

 

[Aladin Akyurek]

It's closer. At least the formula works. Unfortunately, the answer it give me is "1" when all 7 cells are empty. I was hoping for an answer of 7 because they are all empty and 6 if there is a "D" in one of the cells. I hope this makes sense and apologize for the confusion.

Did you apply control+shift+enter as asked?
Control+shift+enter means press down the control and the shift keys at the same time while you hit the enter key. If done correctly, Excel itself puts a pair of { of } around the formula in recognition.