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)))

 

[ravi2628]

Dear jpkreider ,

Could you share a sample Data. based on your query i thought you may require this formals.




[TABLE="width: 568"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD]1[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]2[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]3[/TD]
[TD]3[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]4[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]5[/TD]
[TD]5[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]6[/TD]
[TD]6[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]7[/TD]
[TD]7[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]8[/TD]
[TD]8[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]9[/TD]
[TD]9[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]10[/TD]
[TD]10[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD]11[/TD]
[TD]11[/TD]
[/TR]
[TR]
[TD]Count Blank Values using Count Blank Formula[/TD]
[TD]=COUNTBLANK(B1:B15)[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Count using Count Formula[/TD]
[TD]=COUNTIF(B1:B15,"")[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Sum if Value is Blank[/TD]
[TD]=SUMIF(B1:B15,"<>")[/TD]
[TD]66[/TD]
[/TR]
</tbody>[/TABLE]

 

[jpkreider]

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.

Sorry about that! I tried the ctrl+shift+enter and now we're getting really close! I get an answer of 6, but all 7 cells are empty. But, I did try to enter "D" on some of the selected cells and it does reduce the total, which is great!! Just need to get that initial answer of 7 to start. Is there something else I should add or remove to the formula? Thanks again for your help!!

 

[Aladin Akyurek]

Sorry about that! I tried the ctrl+shift+enter and now we're getting really close! I get an answer of 6, but all 7 cells are empty. But, I did try to enter "D" on some of the selected cells and it does reduce the total, which is great!! Just need to get that initial answer of 7 to start. Is there something else I should add or remove to the formula? Thanks again for your help!!

See the implementation: https://www.dropbox.com/s/kxsmu9lii...ust cells D6,D8,D10,D16,D18,D20,D22.xlsx?dl=0