Lookup one column and sum another column

[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.

 

[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

(e-mail address removed)
(e-mail address removed) with @tiscali.co.uk

 

[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.

 

[Dave Peterson]

ps. Debra Dalgleish has lots of notes on sum functions:
http://www.contextures.com/xlFunctions01.html