Formula structure

[Excel Erick]

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!

 

[Lars-Åke Aspelin]

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

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")*(D1100))

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

Hope this helps / Lars-Åke

 

[RagDyeR]

Try this:

=Sumif(A:A,"Unpaid",D)
--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

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!

 

[Max]

If your data starts in row 2 down
you could have this in say, E2:
=IF(A2<>"Unpaid","","Balance owing:
"&TEXT(SUMIF(A$2:A2,"Unpaid",D$22),"$#,##0.00"))
and copy E2 down as far as required
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:21,000 Files:370 Subscribers:66
xdemechanik