Multi-Column Counting - COUNTA or other Options

The answer is what I'm looking for, but I don't want to have to create a fourth column to keep running totals of each row, if that makes sense.

ArgomIke,

Please have look at Haseeb's solution..i think thats the one you are looking out for without a Helper Column however most times as mentioned by MarvinP I agree that Helper columns are helpful to not only break the code but also help in checking errors..


Good WOrk..Haseeb A..

@ HaseebA - Can you please explain the code as I never knew that we could also use the Multi_Column Ranges as a Starting Point in an Offset...?
Off-Late I have also been given to understand that we can also use an Index:Index Function instead of the Offset as the latter is VOlatile..

SO can this also be modified into an Index:Index approach..

Would really appreciate that...Thnks in advance..

Warm Regards
e4excel