FormulA help

J

jennifer

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!
 
J

Jim Thomlinson

You are little thin on details but take a look at SumIf

=sumif(CriteriaRange, Criteria, SumRange)
 
J

jennifer

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!
 
E

Eduardo

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
 
J

jennifer

Thank you sooooooo much for your help!

Eduardo said:
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
Click to expand...
 
Top