Hey All,
I have formula below to count the total value based on the criteria of date range, if the value within a column is within defined named list of "List1", if the value of another column = "CC", and finally if the value of a final column matches values within "List2". The problem I am running into is that having two defined named lists in the formula is causing it to give an incorrect value for some reason. When I have taken one of the lists out and replaced it with simply adding the individual values of the critieria on the list the formula works, however that will take me ages to do with the amount of cells I need to do this for. So I'm wondering if there is an easy way to make this formula work without having to write a mile long formula for over 100 cells.
=SUM(COUNTIFS('Soft Data'!$K:$K,">="&DATE(2021,1,1),'Soft Data'!$K:$K,"<="&DATE(2021,2,1),'Soft Data'!$D:$D,List1,'Soft Data'!$R:$R,"CC",'Soft Data'!$T:$T,List2))
(Unfortunately I cannot provide the file version for this)
Bookmarks