Help...Summing Items Scattered in a list

Greetings again O Great ones!

I need a total sum of an item that my be scattered several times in a list.

For example, lets say the following is A1 thru B4 in a spreadsheet.
ProjectX $10
ProjectY $5
ProjectZ $10
ProjectX $2

I need to calculate the total $ for ProjectX. In this case the result should be $12.

Use SUMIF:

=SUMIF([range],Project X)

Dave
--
Brevity is the soul of wit.


"modicon2" wrote:

>
> Greetings again O Great ones!
>
> I need a total sum of an item that my be scattered several times in a
> list.
>
> For example, lets say the following is A1 thru B4 in a spreadsheet.
> ProjectX $10
> ProjectY $5
> ProjectZ $10
> ProjectX $2
>
> I need to calculate the total $ for ProjectX. In this case the result
> should be $12.
>
>
> --
> modicon2
> ------------------------------------------------------------------------
> modicon2's Profile: http://www.excelforum.com/member.php...fo&userid=4158
> View this thread: http://www.excelforum.com/showthread...hreadid=573797
>
>