Jul 06 2018 10:45 AM
So i have this excel spreadsheet that tallies all of the info collected into certain tabs and columns. The issue i have is that the formula work for one set of data but when i change the variables for the next set it gives me a FALSE response. Any help would be appreciated. Below is the formula its self and the 2 variables. Im trying to get it to where only the two variables have to change on each tab and not the formula.
=IF(AND(Responses!A:A>=$K$22,Responses!A:A<=$L$22),SUMIF(Responses!C:C,A2,Responses!D:D))
K22= 6/1/2018
L22= 6/30/2018
Jul 06 2018 12:42 PM
Hey Brian-
Hope you're having a good Friday. It look like you're missing the false portion of the if formula so when the true evaluation doesn't happen it will just return FALSE:
=IF(AND(Responses!A:A>=$K$22,Responses!A:A<=$L$22)
,SUMIF(Responses!C:C,A2,Responses!D:D), YOUR FALSE ARGUMENT GOES HERE)
Jul 07 2018 08:35 AM
SolutionIs that array formula?
Anyway, why don't you use SUMIFS like
=SUMIFS(Responses!D:D,Responses!C:C,A2,Responses!A:A,">="&$K$22,Responses!A:A,"<="&$L$22)
Jul 07 2018 09:14 AM
that worked fantastically!!! Thanks so much I have been racking my brain for this for a week and that didn't even cross my mind. Thanks again!
Jul 07 2018 08:35 AM
SolutionIs that array formula?
Anyway, why don't you use SUMIFS like
=SUMIFS(Responses!D:D,Responses!C:C,A2,Responses!A:A,">="&$K$22,Responses!A:A,"<="&$L$22)