How can I combine the functions of a vlookup and sumif without a p

[hobbeson]

It wasn't clear what the solution was from previous posts so I thought I ask
the question again.

I essentially want a function that can look at 1 column for a specific
criteria and then sum a 2nd column when the criteria is found. So for
examples

C1 C2
Red 9
Green 10
Red 2
Blue 6
Yellow 22
Red 18
Brown 23

I want something that will give me the sum of the number associated with red
but for many more data points than this.

[PC]

=SUMIF(C1:C7,"red",D1:D7)

For more than one criteria column use (add as needed)

=SUMPRODUCT((B1:B7="something")*(C1:C7="red")*(D1:D7))

HTH

PC


"hobbeson" <[email protected]> wrote in message
news:[email protected]...
> It wasn't clear what the solution was from previous posts so I thought I
ask
> the question again.
>
> I essentially want a function that can look at 1 column for a specific
> criteria and then sum a 2nd column when the criteria is found. So for
> examples
>
> C1 C2
> Red 9
> Green 10
> Red 2
> Blue 6
> Yellow 22
> Red 18
> Brown 23
>
> I want something that will give me the sum of the number associated with
red
> but for many more data points than this.

[Hobbeson]

Thanks. That's perfect.

"PC" wrote:

> =SUMIF(C1:C7,"red",D1:D7)
>
> For more than one criteria column use (add as needed)
>
> =SUMPRODUCT((B1:B7="something")*(C1:C7="red")*(D1:D7))
>
> HTH
>
> PC
>
>
> "hobbeson" <[email protected]> wrote in message
> news:[email protected]...
> > It wasn't clear what the solution was from previous posts so I thought I
> ask
> > the question again.
> >
> > I essentially want a function that can look at 1 column for a specific
> > criteria and then sum a 2nd column when the criteria is found. So for
> > examples
> >
> > C1 C2
> > Red 9
> > Green 10
> > Red 2
> > Blue 6
> > Yellow 22
> > Red 18
> > Brown 23
> >
> > I want something that will give me the sum of the number associated with
> red
> > but for many more data points than this.
>
>
>