Maybe this.....
=IF(COUNT(A1:A15)=15,SUM(A1:A15),"")

Vaya con Dios,
Chuck, CABGx3



"Mike Milmoe" wrote:

I have data that is consolidated in columns (up to 15 columns). I want to
put a total at the end of the rows, which is not a problem. What I need
however is to delete the columns that don't get used (say if they only
consolidate 10 columns). I know there is a way to find last cell of data for
a column, but is their the same functionality to find the last cell in rows?

Thanks!

Mike