I have attached a sample sheet. I am wanting to total the sum of Column L into Cell N2 if the Row in Column A has a Y in it. The sheet will essentially be a total collection of all the proposal created for my companies sister company. I would like to record when the are sold or not and then total the sold into a specific cell. If using a number instead of a letter would make the formula easier, that would be fine. I could use like 1 for sold and 0 or 2 for not sold. Would greatly appreciate any help.
Thanks,
Bookmarks