Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 ! |
#2
|
|||
|
|||
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" wrote in message ... 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 ! |
#3
|
|||
|
|||
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" wrote in message ... 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 ! |
#4
|
|||
|
|||
You're welcome. Thanks for the feedback!
Biff "PacRat2001" wrote in message ... 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" wrote in message ... 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 ! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|