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.