Formula needed for dividing 2 sets of cells and excluding adjacent text cells

1. Formula needed for dividing 2 sets of cells and excluding adjacent text cells

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.

2. Re: Formula needed for dividing 2 sets of cells and excluding adjacent text cells

Try

=SUMIF(C1:C10,"<>x",A1:A10)/SUMIF(C1:C10,"<>x",B1:B10)

3. Re: Formula needed for dividing 2 sets of cells and excluding adjacent text cells

Is this a continuation of this thread?

http://www.excelforum.com/excel-form...red-cells.html.

If so, it may be easier to continue on that 1 (we can remove the "solved")

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1