How do I search for specific text and sum the cell to the right?

How can I set up 1 cell to search for a specific text, then sum the cell next
to it for as many instances of the text? Thanks for any help !

Hi!

Try this:

Column A contains the text, column B contains the values to sum:

=SUMIF(A1:A50,"text",B1:B50)

OR:

C1 = text

=SUMIF(A1:A50,C1,B1:B50)

Biff

"PacRat2001" <[email protected]> wrote in message
news:[email protected]...
> How can I set up 1 cell to search for a specific text, then sum the cell
> next
> to it for as many instances of the text? Thanks for any help !

Thanks Biff,

Your first suggestion has done the trick for me.

Much Appreciated ..... PacRat2001
"Biff" wrote:

> Hi!
>
> Try this:
>
> Column A contains the text, column B contains the values to sum:
>
> =SUMIF(A1:A50,"text",B1:B50)
>
> OR:
>
> C1 = text
>
> =SUMIF(A1:A50,C1,B1:B50)
>
> Biff
>
> "PacRat2001" <[email protected]> wrote in message
> news:[email protected]...
> > How can I set up 1 cell to search for a specific text, then sum the cell
> > next
> > to it for as many instances of the text? Thanks for any help !
>
>
>

You're welcome. Thanks for the feedback!

Biff

"PacRat2001" <[email protected]> wrote in message
news:[email protected]...
> Thanks Biff,
>
> Your first suggestion has done the trick for me.
>
> Much Appreciated ..... PacRat2001
> "Biff" wrote:
>
>> Hi!
>>
>> Try this:
>>
>> Column A contains the text, column B contains the values to sum:
>>
>> =SUMIF(A1:A50,"text",B1:B50)
>>
>> OR:
>>
>> C1 = text
>>
>> =SUMIF(A1:A50,C1,B1:B50)
>>
>> Biff
>>
>> "PacRat2001" <[email protected]> wrote in message
>> news:[email protected]...
>> > How can I set up 1 cell to search for a specific text, then sum the
>> > cell
>> > next
>> > to it for as many instances of the text? Thanks for any help !
>>
>>
>>