SUMIF or ?????

[yh73090]

This information is exported f rom Microsoft Access Report.
What I need is a function, VBA or formula that will calculate the
"Charge" amount in column "B". The totals in Column "B" at present are
manually entered and very tedious. The rows vary and the rows total
over 4000.

I searched and found parts of what I needed but not exactly and I am a
Newbie to Excel.

Thanks,
Yo

Attachment filename: book1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=641490

 

[Frank Kabel]

Hi
try
SUMIF(A:A,"Charge",B:B)