Cell summing, multi conditions

  • 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.

  • Re: Cell summing, multi conditions

    Your best bet would be to utilise a SUMIF Formula.

    e.g. =SUMIF(A1:C10,"AddA",B1:C10)

    However as you are using more than 1 condition for the summing I suggest that you insert and additional column into the sheet which includes an if statement along the lines of

  • Re: Cell summing, multi conditions

    try this sumproduct formula:

    Xlite :sheep:
    [st]All you need to learn VBA is an internet connection and Ozgrid.com[/st]

  • Re: Cell summing, multi conditions


    D52, copied across:


    Hope this helps!

  • Re: Cell summing, multi conditions

    Thanks for the help. I ended up just writing a formula that checked each cell individually to see if it was positive and then if so added it. Thanks for getting back to me though.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!