=IF(A19="Total Revenue:",B19,0)
I don't know what you were trying to do with the TRIM function, but it
didn't seem to be doing anything for you. Perhaps you need to look the
function up in Excel help to remind yourself what it does?

Copy the formula up and down the column if you want it in the other rows.
--
David Biddulph

nt wrote:
=IF(A3:A200=(TRIM("Total Revenue:")),B3:B200,0)

If the text Total Revenue appears in A19, I would like Excel to
return the corresponding data in B19. If not, then return 0.

What am I doing wrong? I have looked throughout this site and am not
finding my answer so if it has been answered before, please point me
to the correct place. My apologies/thanks in advance