Prev: Check if variable is range
Next: budget setup
From: Roger Govier on 11 May 2010 11:07
Hi Nadine

Did you see my second suggestion to you, where I was proposing that the
Payments were recorded on a separate sheet.
They could be entered on separate rows, or in successive columns along a
single row.
Then on your main sheet, have a SUMIF formula to give the single value
of all payments made so far.

As I said send me a copy of your workbook if you wish.
roger at technology4u dot co dot uk

--
Regards
Roger Govier

Nadine wrote:
> Ed,
>
> Thanks for the link. Unfortunately I didn't see a way to add 20+ pmt per
> invoice when my worksheet contains 1000+ lines of invoices. Thanks for the
> link, though. I'm going to browse it further.
>
> "Ed Ferrero" wrote:
>
>> Hi Nadine,
>>
>>> Does anyone have any thoughts on how to arrange this in Excel 2003:
>> Some thoughts here
>> http://edferrero.com/ExcelTutorials/ExcelDatabaseTutorialPart1/tabid/90/Default.aspx
>>
>> Ed Ferrero
>> www.edferrero.com
>>
>> .
>>
First  |  Prev  | 
Pages: 1 2
Prev: Check if variable is range
Next: budget setup