Countifs Anchored In Table Alternative

umplebyuk

New Member
Joined
Apr 22, 2010
Messages
25
Hi Guys,

I wonder if anyone can help.

Instead of using the below formula "=COUNTIFS($A$1:$A3,$A3,$B$1:$B3,$B3)" where the 3 does not have a dollar so that the range can expand.

Is there a way to do the same calculation but within a table?

The above formula is ok but if you sort the data it distorts the result.

Any thoughts welcome,

Thank you in advanced,

James
 

Some videos you may like

Excel Facts

Excel motto
Not everything I do at work revolves around Excel. Only the fun parts.

Watch MrExcel Video

Forum statistics

Threads
1,109,157
Messages
5,527,128
Members
409,749
Latest member
esmarques

This Week's Hot Topics

Top