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 !
|