Those blo**y Formulas

HI All - I have creatsed a list of creditors in column a that vary from a-z. i have got 3 or 4 diffrent suppliers for each letter and and each supplier is totaled.
Iwould like a formula that sum up only the total of each individual supplier. Is this possibile.???

Help greatly appreciated
Thanks

sumif! if your suppliers are in say A1:a50,and your numbers are in b1:b50.I
dont know how you would refer to your suppliers to extract their data but
say you type their name in cell c1,=sumif(A1:A50,indirect('"C1"),B1:B50)The
only caveat here is your typing in cell c1 must be EXACTLY the same as the
supplier name in the list
I used a drop down list to choose my supplier name,using the actual
suppliers list(a1:a50)-
paul
remove nospam for email addy!



"jhill" wrote:

>
> HI All - I have creatsed a list of creditors in column a that vary from
> a-z. i have got 3 or 4 diffrent suppliers for each letter and and each
> supplier is totaled.
> Iwould like a formula that sum up only the total of each individual
> supplier. Is this possibile.???
>
> Help greatly appreciated
> Thanks
>
>
> --
> jhill
> ------------------------------------------------------------------------
> jhill's Profile: http://www.excelforum.com/member.php...o&userid=23274
> View this thread: http://www.excelforum.com/showthread...hreadid=381153
>
>