Help with Countifs/Sumproduct Formula
UPDATE: The 10 should be 7. (1*5+1*2)
I have a 2 axis grid. The Cells inside the grid all have letter abbreviations. I'm trying to do subtotals of each row.
How can I make a formula that will sum the products of two rows, when one of the rows has a specific character in the cell?
On Day 1 There are 5x BLUE team that are W (Work) and 2x YELLOW team that are W (WORK) for a total of 7 People working that day. The subtotal column checks every cell in the row. If there is a W, then it will multiply 1 * the QTY value in the top Row.
I'm thinking It involves a combination of SUMPRODUCT and COUNTIFS, but I've been struggling trying to figure this out.
Please help if you can.
Help Article Resources
Check out the Formula Handbook template!