Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|