# Count cells with cretria to adjacent cells

1. ## Count cells with cretria to adjacent cells

Dear All

could anyone help me find how many cells matched the creteia based in adjacest cells as shown in attached spreadsheet and picture?

Thanks

2. ## Re: Count cells with cretria to adjacent cells

Based on that sample, what would the answers be?

3. ## Re: Count cells with cretria to adjacent cells

Thank you FDibbins

I want to put formulas in B10:B12 that reflects on desired results in C10:C12

Thanks again

4. ## Re: Count cells with cretria to adjacent cells

Apologies if I was not clear, I meant, what would the actual answers here be?

5. ## Re: Count cells with cretria to adjacent cells

OK If I understand you correctly...
equal pay =SUMPRODUCT(--(\$C\$4:\$C\$8=\$D\$4:\$D\$8))
Overpay=SUMPRODUCT(--(\$C\$4:\$C\$8>\$D\$4:\$D\$8))
Underpay=SUMPRODUCT(--(\$C\$4:\$C\$8<\$D\$4:\$D\$8))

6. ## Re: Count cells with cretria to adjacent cells

The second and third questions are easy:

=SUMPRODUCT(1*(\$C\$4:\$C\$8<\$D\$4:\$D\$8))

=SUMPRODUCT(1*(\$C\$4:\$C\$8>\$D\$4:\$D\$8))

The first is not clear. Do you want the number of people getting the same pay? If so, what happens if, for example, two are getting 40 and two 60 - what would the answer be?

7. ## Re: Count cells with cretria to adjacent cells

Ali, I think you got those 2 the wrong way round?
overpaid = 1 (Ahmed)
underpaid = 2 (last 2)

8. ## Re: Count cells with cretria to adjacent cells

Dear All Thank you for your help.

I have got how I wanted.

The first is not clear. Do you want the number of people getting the same pay? If so, what happens if, for example, two are getting 40 and two 60 - what would the answer be?
@Dear AliGW, I meant how many have got the exact amount (not under paid, nor over paid).

I really appreciated all your support.

Thanks again
Ahmed

9. ## Re: Count cells with cretria to adjacent cells

Hi Dear, Just one thing.. can I ignore in balank rows?

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