Formula to match data from one sheet to another, then calculate the total if a different column true

Christine Lazzaro

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!

Samuel Mueller

Looks like you got your range and criteria flipped, see what happens with this

=SUMIFS({SOURCEpromasterWinningAmount},{SOURCEpromasterAccountNumber},[OS ACCOUNT CODE]@row, {SOURCEpromasterProcureApproval},"Approved")

Samuel Mueller

Looks like you got your range and criteria flipped, see what happens with this

=SUMIFS({SOURCEpromasterWinningAmount},{SOURCEpromasterAccountNumber},[OS ACCOUNT CODE]@row, {SOURCEpromasterProcureApproval},"Approved")

Christine Lazzaro

It worked! I am SOOOOOOOOOOOOOOOOO GRATEFUL! Thank you!!!