Try this...
Assuming there will always be at least 1 number on a row...
Enter this formula entered in BG3 and copied down:
=SUM(BF3:INDEX(G3:BF3,MATCH(1E100,G3:BF3)-MIN(3,COUNT(G3:BF3))))
Try this...
Assuming there will always be at least 1 number on a row...
Enter this formula entered in BG3 and copied down:
=SUM(BF3:INDEX(G3:BF3,MATCH(1E100,G3:BF3)-MIN(3,COUNT(G3:BF3))))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks