Sum if certain criteria in another column is met.

[chad13]

I have cells A1:A10 dop down as "Y" or "N". Cells B1:B10 are values. If any of the values in Column A are "Y", then the value in Column B is Bold, Color, and Outlined. I want to sum all the Bold (Color or Outlined) values in Colum B. Is there a way for a formula is B12 to sum every value in Column B that has a "Y" in column A?

Thanks

 

[Mark W.]

Use SUMIF
This message was edited by Mark W. on 2002-11-01 11:44

 

[chad13]

Thanks.............easier that what I anticipated!