Adding only cells with an X in it
Column G35 through G49 may or may not have the letter X in it based on the
product entered in Column A. Cells in Column R adds up the total of the
amounts in Column B times Column F. I need to have 2 totals. One that totals
only the cells in column G when there is an X showing and the second total
(same row - different column) adding all the cells in column R. I hope I am
making a clear question. I am sure the answer is simple, but I cannot figure
this one out. Thanks. Pete
|