Thanks Ace XL..I believe I just need one more step... some rows will have "N/A" showing up in column D that I would like to ignore and treat as if it was $0