Forum Discussion
Solved
Require assistance on data lookup and plotting results
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 ..!!
=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.
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:
=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.
