STUCK in Formula H_ll! lol
I'm terrible at formulas and trying to learn! I need your help PLEASE!
I have a Master sheet where everyone places orders, it contains the an account number to be charged to and total for each order as well as the status of each order, in a separate sheet I have all of the account numbers. In the second sheet I need to create a formula that for each account number go look at the master sheet and find all order with the same account number, and that are "Approved" and tell me the total cost of all of the orders for the account number.
This is what I have thus far & can't figure out what I'm doing wrong…….
=SUMIFS({SOURCEpromasterWinningAmount}, [OS ACCOUNT CODE]@row, {SOURCEpromasterAccountNumber}, {SOURCEpromasterProcureApproval},"Approved")
I would greatly appreciate any guidance!
