=SUM(SUMIFS(DATA!$B$2:$B$543,DATA!$BQ$2:$BQ$543,{"9","10"},DATA!$BT$2:$BT$543,"moderately well",DATA!$CA$2:$CA$543,{"NSW","ACT"}))
this formula when I just asked for a "9" it gave me the perfect answer but when I wanted to combined the response for both a "9" and a "10" it is only giving me the answer as if I had just had the 9
is there a way to fix this formula.
what it is doing is adding up the numbers in column b
if bq has a 9 or 10
if column bt has the words moderately well
if column ca is nsw and act - it is working and giving me this correct data
can you only do this formula with only 1 options with more than 1 choice so either do it for NSW and ACT or choose to do it for the 9 & 10?
I also need to do another formula instead of a 9 and a 10 but I will also need to if it has a 0 , 1 , 2 , 3, 4 , 5 , 6
cheers
this formula when I just asked for a "9" it gave me the perfect answer but when I wanted to combined the response for both a "9" and a "10" it is only giving me the answer as if I had just had the 9
is there a way to fix this formula.
what it is doing is adding up the numbers in column b
if bq has a 9 or 10
if column bt has the words moderately well
if column ca is nsw and act - it is working and giving me this correct data
can you only do this formula with only 1 options with more than 1 choice so either do it for NSW and ACT or choose to do it for the 9 & 10?
I also need to do another formula instead of a 9 and a 10 but I will also need to if it has a 0 , 1 , 2 , 3, 4 , 5 , 6
cheers