Looking for formula that will copy text in columns to the end totals column

I don't really know how best to explain this but Attached is a worksheet that has multiple columns of names and figures. At the end I have the overall totals. I have added all the figures using a simple SUM() formula, that's easy but I am looking for a formula that I can use that will also bring the names along next to the overall figures column. You can see the highlighted column in yellow is in need of the names.

Your help would be much appreciated

Put in S3
=IF(A3<>"",A3,IF(D3<>"",D3,IF(G3<>"",G3,IF(J3<>"",J3,IF(M3<>"",M3,IF(P3<>"",P3,""))))))

make sure column S is formatted as General

Originally Posted by dosydos

Put in S3
=IF(A3<>"",A3,IF(D3<>"",D3,IF(G3<>"",G3,IF(J3<>"",J3,IF(M3<>"",M3,IF(P3<>"",P3,""))))))

make sure column S is formatted as General

That works dosydos. Thank you very much

PROBLEM SOLVED

Originally Posted by FlameRetired

Since the names appear to be all the same across this would be another way. In S3 this formula filled down.

Formula:

Please Login or Register  to view this content.

The first one works better. Not all the names are in all the columns

Formula cell S3 =LOOKUP(REPT("z",255),A3:P3)

Originally Posted by thuythanh

Formula cell S3 =LOOKUP(REPT("z",255),A3:P3)

That works as well. Thanks thuythanh