Lookup with Sum Function?? Please Help

[Justin Miller]

Helo there,

I am looking to have a formula that looks to a seperate sheet and finds all items named a certain letter code in column a, then return the sum of all of the dollar amounts associated with the coded letter from a different column on the same sheet back to the original sheet. Know i have done something similar with indirect matches in the past, but was wondering if anyone had a quick answer.

Cheers,

J

 

[GS]

Helo there,

I am looking to have a formula that looks to a seperate sheet and finds all
items named a certain letter code in column a, then return the sum of all of
the dollar amounts associated with the coded letter from a different column
on the same sheet back to the original sheet. Know i have done something
similar with indirect matches in the past, but was wondering if anyone had a
quick answer.

Cheers,

J

Have a look at the SUMIF() function...

--
Garry

Free usenet access at http://www.eternal-september.org
ClassicVB Users Regroup!
comp.lang.basic.visual.misc
microsoft.public.vb.general.discussion

 

[Mehmet Esen]

Helo there,

I am looking to have a formula that looks to a seperate sheet and finds all items named a certain letter code in column a, then return the sum of all of the dollar amounts associated with the coded letter from a different column on the same sheet back to the original sheet. Know i have done something similar with indirect matches in the past, but was wondering if anyone had a quick answer.

Cheers,

J

I agree with SUMIF() function. If you have a date column in where the
transaction date is written, you can use "<="& to sum to date
figures.
For certain letter code you should validate the column with certain
data.