Lookup one column and sum another column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Maddoktor - 02 Jan 2007 22:44 GMT

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.

Reply to this Message

Sandy Mann - 02 Jan 2007 22:58 GMT

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)

Signature

HTH

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

sandymann2@mailinator.com
Replace@mailinator.com with @tiscali.co.uk

> Hi all,,
>
[quoted text clipped - 5 lines]
>
> Thanks in advance.

Reply to this Message

Dave Peterson - 02 Jan 2007 23:00 GMT

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

> Hi all,,
>
[quoted text clipped - 5 lines]
>
> Thanks in advance.

Signature

Dave Peterson

Reply to this Message

Dave Peterson - 02 Jan 2007 23:01 GMT

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

> Hi all,,
>
[quoted text clipped - 5 lines]
>
> Thanks in advance.

Signature

Dave Peterson

Reply to this Message

Rate this thread: