Posted to microsoft.public.excel.worksheet.functions

LWilson

external usenet poster

Posts: 33

Nesting

I've got a table of data...

Loan number, tran code, acct, amt.

I need to sum the amounts for the loan number that equal a certain tran code
and acct number. For example, sum acct #11900 for tran codes 88 and 6 for a
certain loan number. The table has several transactions for one loan number.

Can someone help?? My problem is looking up the loan number before summing
the information I need.

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
Nesting	Donna	Excel Worksheet Functions	8	April 3rd 08 08:05 PM
OR Nesting?	Karel	Excel Discussion (Misc queries)	2	March 27th 08 03:52 AM
NESTING FORMULA	Tonya	Excel Worksheet Functions	1	August 29th 06 09:21 PM
IF - Nesting... almost got it - need a bit of help	AngelaG	Excel Worksheet Functions	1	August 22nd 05 10:30 PM
nesting sum if and	BMSpell	Excel Worksheet Functions	2	January 20th 05 05:10 PM

All times are GMT +1. The time now is 05:04 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us