I am trying to apply the formula for sumif's based on a fixed range, and I cannot get results.
Screenshots of issue:
I am required level 10 reputation to be able to post images so sorry for the inconvenience. I just included links for images.
Formula:
=sumifs($D$2:$D$1000 , $C$2:$C$1000 , "Done", $E$2:$E$1000 , "Waqas")
Does anyone know why this formula is not returning a sum?
The "problem" formula actually works just fine. But it has a flaw: it can't be easily copied down the column to apply to other workers. A generic version of the formula is =sumifs($D$2:$D , $C$2:$C , "Done", $E$2:$E , F5) where F5 is the name of the worker. Note, this also provides for infinite column lengths.
Another option is that the OP could list the names of workers by using =sort(unique(E2:E)). While the OP may need a longer list for other purposes, this shouldn't stop using a function to pickup names from a master list.