ExcelBanter - View Single Post

Lars-Åke Aspelin[_2_]

On Wed, 24 Dec 2008 15:46:01 -0800, Excel Erick <Excel
wrote:

I am trying to figure out a formula to do the following:
My spread sheet is made up of several columns of types of information. The
two columns that are important to the formula are A and D. A has a
user-defined value of "Paid" or "Unpaid". Column D has a user-defined
currency value. In a separate cell I want to have a running total displayed -
a SUM of the currency amounts in column D associated with (in the same line
as) the "Unpaid" values in column A. The information in this cell should look
like this "Balance owing: $XXXX" where XXXX is the running total.

Please help!

Try this formula:

="Balance owing: $"&SUMPRODUCT(A1:A100="Unpaid")*(D1:D100))

Change the 100 on both places if you have more than 100 rows of data.

Hope this helps / Lars-Åke