=SUMIF(row of status,"paid",row with $)
Quote:
Originally Posted by Shaun 84 Targa
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...
|
__________________
1987 930, (Imagine Auto) 3.4L, dual plugged, Electomotive, k27HFS, Tial WG, SC Cams, Kokeln IC, GHL headers, HKS EVC5 boost controller, Bilstein coil overs, Big Reds on Front
|