Forum Discussion

soccer85's avatar
soccer85
Copper Contributor
Dec 21, 2020

Help with Excel formula - Countif - Sumproduct

Trying to identify how many items have been completed less than 1wk, less than 2wk, On time, greater than 3wk, greater than 2wk and greater than 1 week from its due date (Column P). Trying to use Col...
excel
Formulas and Functions
soccer85's avatar
soccer85
Copper Contributor
Jan 07, 2021

Riny_van_Eekelen 

 

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. 

Spoiler
 
Riny_van_Eekelen's avatar
Riny_van_Eekelen
Platinum Contributor
Jan 07, 2021

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.

 

 

Resources