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.
=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.