Hi Maria

not sure of exactly what you want
but does
=IF(A1="Fred",B1,0)
give you what you want? if not could you type out an example of your data
and what you want to see (please don't attach a workbook just type it out)

--
Cheers
JulieD

check out www.hcts.net.au/tipsandtricks.htm
....well i'm working on it anyway
"Maria" wrote in message
...
I want to check the value of one column (A) and then depending on the
outcome add the value in the same row but column B to a total. Can I do
this
in a single cell formula or do I have to have an extra column that does
the
logic test and then a cell to do the totalling?