Posted to microsoft.public.excel.worksheet.functions

crabatin

external usenet poster

Posts: 3

How do I sum the last 5 nonzero numbers in a row?

I have values in a table and want to add a column on the right that will look
to the left at the previous 20 columns and find the last 5 numbers
(rightmost) that are not zero and sum them.

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Address of last nonzero value	Wigi	Excel Worksheet Functions	0	August 7th 08 04:30 PM
Address of last nonzero value in a range	Ron Coderre	Excel Worksheet Functions	0	August 7th 08 03:21 PM
Locating Last Nonzero Cell in a Row	wilby31	Excel Worksheet Functions	6	September 15th 05 08:19 PM
nonzero value	DAVID	Excel Worksheet Functions	2	January 10th 05 05:07 PM
find first nonzero value in column	DAVID	Excel Worksheet Functions	0	January 10th 05 01:11 PM

All times are GMT +1. The time now is 11:26 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us