HELP with Formulas

[Teri]

Hi there,

I'm trying to create a spreadsheet that will allow me to search for a
certain code (created by myself in a text format) and take the number in the
corresponding column to give me a total for all of that one particular code.

Any help or suggestions would be appreciated. Thanks!!

[Peter Aitken]

"Teri" <[email protected]> wrote in message
news:[email protected]...
> Hi there,
>
> I'm trying to create a spreadsheet that will allow me to search for a
> certain code (created by myself in a text format) and take the number in
> the
> corresponding column to give me a total for all of that one particular
> code.
>
> Any help or suggestions would be appreciated. Thanks!!

Look at the SUMIF function in online help.


--
Peter Aitken

Remove the crap from my email address before using.