Sumif Equivalent In Access

  • I am looking for a SUMIF equivalent utility in Excel. I am running couple of queries to create desired output (which comes into 16 columns in Access). Once this output is generated I need to recalculate values in one of the columns. In Excel I could recalculate those values by using SUMIF formula but I am not sure how to do that in Access.

    I have attached the excel spreadhsheet that shows the final results that I need to generate (it’s from row 20 to row 30 in the attached spreadsheet). I first add some new records to the existing records by running a query and then I need to update column N which is the sum of values (in column L) for each fund code (in column M).

    With the help of people on forums I have figured out how to add new records to existing records by running few queries. But now I am not sure how to change values in column N. As mentioned earlier in excel I can use the “SUMIF” formula to generate the desired results but I am not sure how to do that in Access.

    I would really appreciate if you can suggest a way to do so.

    Thanks for the help.



  • Re: Sumif Equivalent In Access


    I am not certain that there is an equivalent to SUMIF in Access; a workround might be to create a new table for the Fund values and their totals, and then running an update query based on this new table.


  • Re: Sumif Equivalent In Access


    What you really should be looking at is aggregate queries and/or crosstab queries.

    There is no real equivalent of Excel's SUMIF in Access.

    But it can be far easier sometimes to summarise data in Access.


Participate now!

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