View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
knbsmith11
 
Posts: n/a
Default Conditional Statement Question

I need a formula for the following synario:

Column A = either AG, AP or WW
Column B = %
Column C = Amount
and I have 4500 rows of data below

What I want to do is say if column A = AG, than multiply column B by Column
C and add up all the rows that meet the criteria and put them in this cell.

Can anyone help?