A1:A10 = numbers
B1:10 = numbers
C1:C10 = text range
D1 = Formula
I want to add all the numbers in the A range and divide the total by the total sum of all the B range however I want to exclude from the totals in both A & B cells any adjacent with specific text in C1:C10.
EXAMPLE: letter “X” so all x’s in C1:C10 will not calculate the totals in A & B to solve for D.
Bookmarks