Good afternoon. I have been trying to create a formula that would conduct the following on one sheet where data is residing on another -
1. Where (Extract!T2:210000, "=Declined"
2. Sum $'s (Extract!H2:H10000,">0" and Sum $'s (Extract!K2:k10000,">0"
I know my end results should end up being:
H (Declined Credits) value = $19,344.77
K (Declined Refunds)value = $128,035.40
Total Declines (H + K) = $147,380.17
Bookmarks