I sell products to Nurses and Teachers.
In one column I have a drop down, where I flag the product as Nurse or Teacher. In the next column I have the amount (this is variable not constant).
I am trying to write a formual that will total the number of products sold to a Teacher (based on the value in the drop down) and to total the corresponding amount to provide a total for Teachers for the month.
So in logical terms it is. IF product = Teacher, then add product amount to monthly total.
Is this doable without having to separate out my products to separate columns?
Bookmarks