I'm looking for help combining my SUMIF together with an AND formula. At least that is what I think I need to do to get it right, however, please correct me if I'm wrong!
In column A I have a list of WBS' which are:
O.QA.SAL.230.01
O.QA.SAL.230.02
O.QA.SAL.230.03
In column B I have Account Numbers which are:
1207000
1110000
1298000
I'm trying to use a SUMIF formula together with AND to return the amount if both conditions are fulfilled by referring to another sheet named "SAPBW_DOWNLOAD" where column A in this sheet contains WBS info, column B account numbers and column C amounts.
EXAMPLE:
SUMIF(SAPBW_DOWNLOAD!$A:A$,$A,SAPBW_DOWNLOAD!$C:$C) <---- right now the formula will pick up the amounts from column C based on the relevant WBS. However, I need it to only pick up the amount if both the WBS and Account Number is there. Hopefully someone is able to understand this and help me with a solution.
See my attachment.
Bookmarks