|
FormulA help
Hello, I have a dropdown menu of vendors, ( column d) and I would like to be
able to get a total for each vendor on the side... Is this possible, if so how do I do this? Thanks for your help. The amounts are in column c. Thanks again! |
FormulA help
You are little thin on details but take a look at SumIf
=sumif(CriteriaRange, Criteria, SumRange) -- HTH... Jim Thomlinson "jennifer" wrote: Hello, I have a dropdown menu of vendors, ( column d) and I would like to be able to get a total for each vendor on the side... Is this possible, if so how do I do this? Thanks for your help. The amounts are in column c. Thanks again! |
FormulA help
Right now i have Amounts in column c, and vendors in column d. Column d is comprised of dropdown list of vendors so that we can select a vendor as we enter the amount. On the side. Say in column I I would like a totla by vendor because there could beseveral entries throughout the month. I hope that is ore helpful detail. I tried sumif but can not make it work. Thanks! "Jim Thomlinson" wrote: You are little thin on details but take a look at SumIf =sumif(CriteriaRange, Criteria, SumRange) -- HTH... Jim Thomlinson "jennifer" wrote: Hello, I have a dropdown menu of vendors, ( column d) and I would like to be able to get a total for each vendor on the side... Is this possible, if so how do I do this? Thanks for your help. The amounts are in column c. Thanks again! |
FormulA help
Hi,
Assuming that you have the vendor name in Cell H1 and you want to find the total amount from column C in cell I1 enter =sumproduct(--(H1=$D$1:$D$10000),$C$1:$C$1000) change range to fit your needs "jennifer" wrote: Right now i have Amounts in column c, and vendors in column d. Column d is comprised of dropdown list of vendors so that we can select a vendor as we enter the amount. On the side. Say in column I I would like a totla by vendor because there could beseveral entries throughout the month. I hope that is ore helpful detail. I tried sumif but can not make it work. Thanks! "Jim Thomlinson" wrote: You are little thin on details but take a look at SumIf =sumif(CriteriaRange, Criteria, SumRange) -- HTH... Jim Thomlinson "jennifer" wrote: Hello, I have a dropdown menu of vendors, ( column d) and I would like to be able to get a total for each vendor on the side... Is this possible, if so how do I do this? Thanks for your help. The amounts are in column c. Thanks again! |
FormulA help
Thank you sooooooo much for your help!
"Eduardo" wrote: Hi, Assuming that you have the vendor name in Cell H1 and you want to find the total amount from column C in cell I1 enter =sumproduct(--(H1=$D$1:$D$10000),$C$1:$C$1000) change range to fit your needs "jennifer" wrote: Right now i have Amounts in column c, and vendors in column d. Column d is comprised of dropdown list of vendors so that we can select a vendor as we enter the amount. On the side. Say in column I I would like a totla by vendor because there could beseveral entries throughout the month. I hope that is ore helpful detail. I tried sumif but can not make it work. Thanks! "Jim Thomlinson" wrote: You are little thin on details but take a look at SumIf =sumif(CriteriaRange, Criteria, SumRange) -- HTH... Jim Thomlinson "jennifer" wrote: Hello, I have a dropdown menu of vendors, ( column d) and I would like to be able to get a total for each vendor on the side... Is this possible, if so how do I do this? Thanks for your help. The amounts are in column c. Thanks again! |
| All times are GMT +1. The time now is 03:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com