ExcelBanter - Count IF/And

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Count IF/And (https://www.excelbanter.com/excel-programming/446867-count-if.html)

GoogleUser

Count IF/And

Hi
I need to write a formula that will have this logic.

IF E6="X" then count for all blanks in F6:K6 and place it in L6

Can someone help me with the proper code.

Tnank you in advance
Gary

joeu2004[_2_]

Count IF/And

"GoogleUser" wrote:
I need to write a formula that will have this logic.
IF E6="X" then count for all blanks in F6:K6 and place
it in L6

I don't see an "if/and" in that logic, so I'm not sure I understand.

Perhaps the following in L6:

=IF(E6="X",COUNTBLANK(F6:K6),"")

All times are GMT +1. The time now is 08:05 AM.