Posts by finder003

Important Notice


Please note that on 14th December 2023 users will experience an expected outage whilst we make upgrades to our network. We anticipate this process may take a couple of hours and so we apologise in advance for any inconvenience.

  • Sum Column According To Another Column

    Re: Sum Values For One Column According To The Values In Another Column?


    I just wanted to quickly add that the problem I have with the SUMIF function is that I have way too many values in columnA and that makes it difficult for me to individually specify the criteria. Is there anyway Excel can automatically sum up the values in column B for all recurrring instances in column A? I noticed i some previous responses that a Pivot table can be used. I have never heard of it or used it before. So please help!!


    Thanks!

  • Sum Column According To Another Column

    I need to add all the data in columns B for all instances of a value occuring in column A
    For eg


    ColumnA Column B


    Apple 4
    Apple 5
    Orange 3
    Orange 5
    Mango 2
    Lemon 1
    Lemon 9


    I want the final result to look like this


    ColumnA Column B


    Apple 9
    Orange 8
    Mango 2
    Lemon 10


    Please help!


    Thanks