I have a worksheet with a column "Folder" and a column "Name"

I need to return the count where the Length of the folder path (Folder) and length of the File name "Name" exceeds 256

I have tried =CountIf(Len([Folder])+Len([Name]),>256) and several variation around that theme but obviously on the wrong track.

I need this to be a value returned in a VBA procedure:

e.g., Msgbox =CountIf(Len([Folder])+Len([Name]),>256)

Hope someone can help. Thank you!!