Require assistance on data lookup and plotting results

[Ramu2603]

All I want from above table is to Count "Priority" and compare data with "Final Status" and plot the count as below

Thanks for help ..!!

[#2 · Accepted solution]

@Ramu2603 

=SUMPRODUCT(N(Tabelle1[Priority]=A17))

This is the formula in cell B17.

=SUMPRODUCT((Tabelle1[[Priority]:[Priority]]=$A17)*(Tabelle1[[Final Status]:[Final Status]]=C$16))  

This is the formula in cell C17 in my example which is filled across range C17:E20. Tabelle1 is the name of the dynamic table in my example. You have to replace Tabelle1 with the name of your table.

[#3]

Hi @Ramu2603 

If you're still in the same context as for Require small help on "Conditional Formatting" you use a Table. If so, why not doing it with a PivotTable - no formula: