I have been away from heavy Excel usage for a couple of years, so I'm struggling to remember things!
I need to subtotal col E for each category in Col D, but including them only if Col B contains "CA". I thought SUMPRODUCT might be the answer, but I can't get this to work:
=SUMPRODUCT(((B2:B9)="CA")*(D2:D9=D300)*(C2:C9)) D300 contains the Category to be subtotaled, e.g. "Computer Equipment." It's returning a #VALUE error. Am I doing something wrong in the formula, or is SUMPRODUCT not the right solution?
Thanks in advance!!
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>
I need to subtotal col E for each category in Col D, but including them only if Col B contains "CA". I thought SUMPRODUCT might be the answer, but I can't get this to work:
=SUMPRODUCT(((B2:B9)="CA")*(D2:D9=D300)*(C2:C9)) D300 contains the Category to be subtotaled, e.g. "Computer Equipment." It's returning a #VALUE error. Am I doing something wrong in the formula, or is SUMPRODUCT not the right solution?
Thanks in advance!!
Col B | Col C | Col D | Col E |
Location | Item | Category | Cost |
CA | 48 Port Switch | Network Equipment | $1,479.00 |
CA | 24 Port Switch | Network Equipment | $925.00 |
CA | Cable Materials | Network Infrastructure | $4,250.00 |
CA | Cable Labor | Network Infrastructure | $18,100.00 |
CA | UniFi access points | Network Equipment | $130.00 |
CA | Warehouse Computers | Computer Equipment | $757.85 |
HQ | Warehouse Monitor | Computer Equipment | $108.53 |
<colgroup><col><col><col><col></colgroup><tbody>
</tbody>