Forum Discussion
Help with Excel formula - Countif - Sumproduct
Thanks it kinda make sense. However, after looking this over. I am trying to eliminate column u i just want to nest the formula i created in column v (If statement) into a countif/sumproduct or whatever works so it looks cleaner. The formula should start on t51. Not sure if the formula in column U can be simplified?
at the end of the day i just want to create a column graph showing the number of items that are with these specific tags" Quick Turnaround" "On Time" etc....
Thanks again.
soccer85 Oh my, what a formula! Why not create a lookup table with the options for each status. An example is included in Sheet4. Then you can avoid these horrible nested IF formulae with hard-coded boundaries and descriptions.
Perhaps an approach you want to apply in other areas of your schedule as well. It seems you have made it overly complicated, but that's just my own humble opinion.