How can you get a total of Column F if Column B contains the word deposit
B Bob Phillips May 13, 2005 #2 =SUMIF(F:F,"Deposit",B;B) -- HTH RP (remove nothere from the email address if mailing direct)
