Lookup one column and sum another column

M

Maddoktor

Hi all,,

Hope someone can help me with the following problem.

I would like to look up Column C for a specific value (i.e. 19) and then
sum the values in Column A that relates directly to the value of 19 in
Column C.

Thanks in advance.
 
S

Sandy Mann

If you mean SUM() values in Column A that are in the same rwo as number 19's
in Column C then try:

=SUMIF(C1:C9,19,A1:A9)

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

[email protected]
[email protected] with @tiscali.co.uk
 
D

Dave Peterson

=sumif(c:c,19,a:a)
is one way.
Hi all,,

Hope someone can help me with the following problem.

I would like to look up Column C for a specific value (i.e. 19) and then
sum the values in Column A that relates directly to the value of 19 in
Column C.

Thanks in advance.
Click to expand...
 
Top