Count numeric values not found in range based on another range

[nickpavlov]

Hello,

Is there a way to count the number of cells in a range that have values that are not in another range on the same sheet?

Example:

Range #01: B9:F13 contains numeric values.

Range #02: L4:AJ6 contains numeric values.

If the values in Range #01 are not found in Range #02 the total count not found will display.

I appreciate any help with this.

Thank you,

[oeldere]

150 views no reply, that indicates the question is not clear to the forummembers.

HOW TO ATTACH YOUR SAMPLE WORKBOOK:

Fast answers need clear examples. Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. Just before posting, scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

[Croweater]

There is probably an excel formula that will do this, but this is much easier IMO.

Please Login or Register  to view this content.

[XLent]

formula wise:

=SUMPRODUCT(--(COUNTIF(L4:AJ6,B9:F13)=0))

[nickpavlov]

Sorry, I thought I responded to this post. Xlent, that worked perfect! Thank you.