Good day excel forum. I'm reaching out for help on what I thought would be a relatively simple formula, but with me not having much experience with the various excel formula and each formula's limitations, I may be trying to tackle this one with the wrong formula. I tried sumifs to no avail.
I've attached a sample worksheet and the formula I'm searching for needs to return the sum of the values in one of the columns in the specified range of N601:AG616 given 2 matching criteria.
The range of values is on Master Sheet 1, and the formulas need to go on Sheet 2 Sum Total (in BH21-BH30).
The formulas in these cells need to return the results you see in BJ21-BJ30 by having a formula that will sum the total of all values in the column of the specified range where the PO# in row 1 of that column on "Master Sheet 1 matches the PO # on Sheet 2 Sum Total (column X), AND where the "Ref #" in B601-616 on Master Sheet 1 matches the Ref # for each row on Sheet 2 Sum Total (column C).
If it's not clear what I'm trying to accomplish, please email me. Thanks so much in advance for your help solving this formula problem for me.
Be Well!
Bookmarks