I am an average Excel user, but not to familiar with constructing formulas. I have a spread sheet I wish to sum as follows:
In column A1:A10 is the letter "A" but it is not in every cell, column B1:B10 contain numbers (in all cells) some are positive and some negative. I need to add only the positive numbers in column B1:B10, but only thoses that have the letter "A" in the ajacent A1:A10 column.
Hope this explains it enough for someone to help...thanks before hand.