hi,
i have an excel worksheet for completion by employees, and i want it to calculate an average gross profit based on criteria they enter under 4 different columns.
for example, column A & B have Product and GP, so do C and D, and E and F, allowing for multiple product sales and GP entries. each month has it's own tab.
i want to calculate how many times "Stone" was sold in either column A, C, or E, which i did, but now need to calculate the average GP for each of those "Stone" sales.
so average GP in column B, D and F only if "Stone" is in A, C or E.
possible??
thanks in advance.