I have an excel file that my employees use to record phone sales for each day. I have a column where either "cing" for cingular, "tmob" for tmobile or "att" for at&t is written when an employee makes a sale. I also have a column "Upgrade" which either gets a yes or a no. Goals for each day are based on points. 1 point for each activation which would be a "no" in the uprgade column, or .5 point for an upgrade. How would i make a cell automatically count how many points my store is at. when an employee makes a sale and enters that info then its automatically updated. Ive included the excel sheet. Thanks
the few times we had more than 28 sales we just opened a new excel and labeled in part 2. And i was thinking of putting the count somewhere on that sales log page. it doesnt matter. Im goin to redesign it but i just dont know what code to use to do the conditional count. thanks for the quick response
However,, if you set this up properly you can have the competitors in three cells and Yes and No in other cells, then you can have a simple table that automatically updates.
See on the attachment, on worksheet Site Log(2), O4:Q10, especially the formulas highlighted in yellow (the six cells otgether use the SUMPRODUCT, whereas the other two in Green sum up the totals and multiply by appropriate number.
old, slow, and confused
but at least I'm inconsistent!