|
Excel Question
I have a spreadsheet of customers and their orders this season. One column is Status (blank or PAID text) and next to it is the invoice amount.
I want a sum of paid and unpaid invoices that changes only by typing PAID in the Status column.
Can this be done? I don't want a row by row summation of IF statements. IF(A2 ="PAID",B2,0) + IF(A3...
__________________
Tru6 Restoration & Design
|