counts repeated number in two different area only once

R

ryguy7272

That compound function doesn't work. Maybe this is what you want:
=IF(COUNTIF(A2:C3,A1)>0,1,0)+IF(COUNTIF(A6:C9,A1)>0,1,0)

Or, this:
=IF(COUNTIF(A2:C3,A1)>0,1,0)+IF(COUNTIF(A6:C9,A1)>1,1,0)

HTH,
Ryan---
 
S

sierra spiegel

Thank you very much, Ryan. Your formula works perfectly.





ryguy7272 wrote:

That compound function does not work.
02-Nov-09

That compound function does not work. Maybe this is what you want
=IF(COUNTIF(A2:C3,A1)>0,1,0)+IF(COUNTIF(A6:C9,A1)>0,1,0

Or, this
=IF(COUNTIF(A2:C3,A1)>0,1,0)+IF(COUNTIF(A6:C9,A1)>1,1,0

HTH
Ryan--

-
Ryan--
If this information was helpful, please indicate this by clicking ''Yes''

:

Previous Posts In This Thread:

EggHeadCafe - Software Developer Portal of Choice
ASP.NET Membership and Roles in Silverlight 3
http://www.eggheadcafe.com/tutorial...62-48ad5c7f70b4/aspnet-membership-and-ro.aspx
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top