New to countif & struggling

AllyOops

New Member
Hi I got some great help on countif a few weeks back! I tried to build on that advice and I am stuck. I would like to better understand why this isnt working:

=IF(AG3="Modify",COUNTIF(\$AA\$2:\$AA\$100000,AA2),"")>1,"Escalate","SomethingElse")

so I tried to simplify with this

=COUNTIF((\$AA\$2:\$AA\$100000,AA2)>1,"Escalate","SomethingElse")

And I am still getting an error....I am missing something here and would like to better understand.

I am trying to look at AG=Modify only and return the word escalate if I have multiple hits in column AA!

Thanks!

Excel Facts

If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.
Try:
=IF(AND(AG3="Modify",COUNTIF(\$AA\$2:\$AA\$100000,AA2)>1),"Escalate","SomethingElse")
or
=IF(AG3="Modify",IF(COUNTIF(\$AA\$2:\$AA\$100000,AA2)>1,"Escalate","SomethingElse"))

Thanks Robert!

Hi,

Can anyone help me on counting this?: I want to count as given below the value should be displayed only once rest should show 0.

 Location Count Adoni - Spoke 3 Adoni - Spoke 0 Adoni - Spoke 0 Agra - Sanjay Place 4 Agra - Sanjay Place 0 Agra - Sanjay Place 0 Agra - Sanjay Place 0 Agra - Sanjay Place 0 Agra - Sanjay Place Many thanks in advace.... Arvind Kushik 0

<TBODY>
</TBODY><COLGROUP><COL><COL></COLGROUP>

Hi Robert,

Please suggest me on this...Also Last two values pasted by mistake (these are only 4 times.."Agra - Sanjay Place"...

Thanks,
Arvnd

Hi Arvind,

I think the correct value for Agra - Sanjay Place is 6, not 4

If so, try this in B2
=COUNTIF(\$A\$2:\$A\$10,A2)*(COUNTIF(\$A\$2:\$A2,A2)=1)
copy down

M.

Excel 2010
AB
1Location Count
5Agra - Sanjay Place6
6Agra - Sanjay Place0
7Agra - Sanjay Place0
8Agra - Sanjay Place0
9Agra - Sanjay Place0
10Agra - Sanjay Place0

</tbody>
Sheet1

Worksheet Formulas
CellFormula
B2=IF(COUNTIF(\$A\$2:A2,A2)=1,COUNTIF(\$A\$2:\$A\$10,A2),0)

</tbody>

<tbody>
</tbody>

Thanks a lot Robert...That is wonderfull..It amazing....!!!!

Arvind

You are welcome.
Thanks for feedback

Replies
3
Views
365
Replies
3
Views
312
Replies
3
Views
844
Replies
5
Views
411
Replies
9
Views
287

1,196,409
Messages
6,015,104
Members
441,870
Latest member
kojack

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back