I am trying to add up certain numbers in each row. So each time 4.4 shows up i want the number to the left of it (can be a different number). At the moment i have INDEX(C5:CN,MATCH($CT$2,C5:CN,0)-1).
CT2=4.4
This gives me the number left to the first occurrence of 4.4, but I am trying to get all of them added together. I have tried the SUMPRODUCT and SUMIF functions but cant seem to get it to work. I am probably just not doing it right
Any help would be much appreciated!
CT2=4.4
This gives me the number left to the first occurrence of 4.4, but I am trying to get all of them added together. I have tried the SUMPRODUCT and SUMIF functions but cant seem to get it to work. I am probably just not doing it right
Any help would be much appreciated!