hi
try this..
=SUMIF(B2:B8,"text",A2:A8)
or
sumif(range with criteria, criteria, range to sum)

Regards
FSt1

"Shirl" wrote:

I am wanting to add numbers in Column B,d,f etc only if it equals the text in
Column A,c,e etc
--
Shirl, NZ