Formula Help
 

I have a worksheet with a few columns in it. In one column I have the name
of a transaction (as in AMEX) and in another column I have a Y or N (for paid
back status); then in another column I have dollar amounts (to the left of
these columns). What I need to do is SUM the dollar amount column, if it
meets the "AMEX" and "Y" criteria only. For instance: I have 7 AMEX
transactions, all different dollar amounts, and only 5 of those with a "Y".
I need to know the sum of those Y and AMEX dollars. Any Ideas??

There are other numerous columns (dates, description, merchant, etc). Do
these columns need to be in any particular order for a formula from above to
work (as like a VLOOKUP does)??

Thanks for the help!

Try this, Rus:
http://www.officearticles.com/excel/...ft_excel.h tm
*******************
~Anne Troy

www.OfficeArticles.com


"Rus" wrote in message
...
I have a worksheet with a few columns in it. In one column I have the
name
of a transaction (as in AMEX) and in another column I have a Y or N (for
paid
back status); then in another column I have dollar amounts (to the left of
these columns). What I need to do is SUM the dollar amount column, if it
meets the "AMEX" and "Y" criteria only. For instance: I have 7 AMEX
transactions, all different dollar amounts, and only 5 of those with a
"Y".
I need to know the sum of those Y and AMEX dollars. Any Ideas??

There are other numerous columns (dates, description, merchant, etc). Do
these columns need to be in any particular order for a formula from above
to
work (as like a VLOOKUP does)??

Thanks for the help!

=SUMPRODUCT(--(A2:A1000="AMEX"),--(B2:B1000="Y"),C2:C1000)

and no, the order is not important.


--

HTH

RP
(remove nothere from the email address if mailing direct)


"Rus" wrote in message
...
I have a worksheet with a few columns in it. In one column I have the
name
of a transaction (as in AMEX) and in another column I have a Y or N (for
paid
back status); then in another column I have dollar amounts (to the left of
these columns). What I need to do is SUM the dollar amount column, if it
meets the "AMEX" and "Y" criteria only. For instance: I have 7 AMEX
transactions, all different dollar amounts, and only 5 of those with a
"Y".
I need to know the sum of those Y and AMEX dollars. Any Ideas??

There are other numerous columns (dates, description, merchant, etc). Do
these columns need to be in any particular order for a formula from above
to
work (as like a VLOOKUP does)??

Thanks for the help!