I need a macro (VBA) code to increment count for the attached table (columns A through D) when the strings in column C or D are blank for the corresponding type.

for example, in the attached picture Column E explains how it should work.

NOTE: car_1 is written as car1 in the string without the "_"

Type ar1 polkaic ycar 1 2010 pploann 3 1yr1 2014 plane 3 bus car 4 bus 2 |year car4 2014 |year bus2 2013 | no blankso increments car 1 car 4 year car4.2014 plane 3 bus 2 Type2Releaseease2Blanks count increment plane 3 count increment plane 3 count year.plane3.2012 year.bus2.2013no blankso increments increment car 1 count increment plane 3 & bus 2 count