match/lookup/sum?

[Scott]

On a worksheet, I am looking to calculate a sum from
random cells in a column...which I need to reference the
cells to the left of this column, which are to match a
cell in a row that has the same name as the name of the
row which I need the total for.
If this makes sense to you please help
Thank you

 

[Bob Phillips]

Scott,

Do you mean something like

=SUMIF(A1:A100,"some value",B1:B100)

where B1:B100 are the numbers, and A1:A100 are the values to checker "some
value" against.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Guest]

Ok did that formula. It is only working for the 2nd cell
in the column. I did change the info in the row and if
it doesnt match it doesnt add to the column. So for some
reason that one works but not the rest of the cells.