Dec 11 2018 05:56 PM
I'm looking for a formula that will use vlookup and sumif to sum a specific column based on 2 criteria. The attached spreadsheet will make the task obvious. I'd like to sum all accounts based on the Org unit which. I'd like to be able to change that Org Unit 10 to another org # like 20 and the amount would change based on that. Please see attached excel sheet for a sample.
Dec 11 2018 06:19 PM
SolutionHi,
You need to SUMIFS function!
So, I've updated the workbook with this formula:
=SUMIFS(Data!$C$2:$C$510,Data!$B$2:$B$510,A5,Data!$A$2:$A$510,$A$2)
But please note that there are some duplicate numbers in Sheet1 / New Account Number column.
Hope that helps
Jan 12 2019 12:26 PM
Jan 12 2019 12:35 PM
Hi @PromiseO1245,
Please check out the resources below that could be helpful to learn how to start using SUMIF/SUMIFS functions:
Hope that helps
Dec 11 2018 06:19 PM
SolutionHi,
You need to SUMIFS function!
So, I've updated the workbook with this formula:
=SUMIFS(Data!$C$2:$C$510,Data!$B$2:$B$510,A5,Data!$A$2:$A$510,$A$2)
But please note that there are some duplicate numbers in Sheet1 / New Account Number column.
Hope that helps