Thanks in advance.
I'm trying to Sum the Capital impact of CRs from the list in rows 15-24 (ignoring Invoices). I have tried using SUMIFs, SUMPRODUCT, and nested IFs, but so far nothing has worked.
I am putting the formula in D4.
The CR indicator is in Column L.
The Capital indicator can be seen in Columns N, Q, T, and W
I SHOULD be seeing a result of $350 if the formula is working correctly.
What ridiculously easy thing am I missing?