Count balnks except ones in certain columns

[blossomthe2nd]

Hi Guys

Im trying to write a formula that coounts blanks in a row, except if its blank in the Column V W X

=SUM(COUNTBLANK(A3:AE3))+(IF(ISBLANK(V3),-1,0)-(IF(ISBLANK(W3),-1,0)-(IF(ISBLANK(X3),-1,0))))

I have tried the following but its not working very well, plus its kinda cumbersome , can anyone help please ?

Thanks

 

[jasonb75]

Try

=countif(A3:AE3,"=")-countif(V3:X3,"=")

 

[njimack]

=sum(if(isblank(a3:ae3),1,0))-sum(if(isblank(v3:x3),1,0))
(confirm with ctrl+shift+enter)

 

[blossomthe2nd]

Hi guys

Thanks for that , I should have clarified , I will have additional columns that I would not like to count ( they wont all be in a sequence)

So if blank between A : AE unless the blanks are in V W X S or U ?

Is there a way to do multiple ifs on this ?

Thanks

 

[jasonb75]

Modifying Neil's suggestion slightly, array confirm with Shift Ctrl Enter

=SUM(--ISBLANK(A3:AE3),-ISBLANK(S3),-ISBLANK(U3:X3))

edit:-

alternatively, if the columns to ignore change, insert a new row at row1 and enter 1 at the top of each column to be excluded.

Hide the new row if desired.

Use the formula

=SUM(IF($A$1:$AE$1,0,--ISBLANK(A4:AE4))) Array confirmed with shift ctrl enter.

 

[blossomthe2nd]

Cool Thanks Guys

Works perfect