This spreadsheet will allow each team member to enter a number for the whisper tone used on an incoming call and then a letter for the real purpose of the call. What I want is a formula at the bottom. let's say in row 80 to total matches at the bottom. for example IF cell e6 = 5 and cell F6 = m, then display a 1 otherwise display a zero.I got that far. Now I have two problems. I want the formula to test every row for matches. Each row is equal to one call and there could be as many as seventy-five calls. Then at the bottom where the test formula is, I want the count to change. If I have to use the above formula for each row, that is fine. I think I can just hide the contents of the cell and lock it so they cannot mess it up. What I do want is after the first row the next formula would be IF cell E7 = 5 and cell F7 = m, then go back to total that is in Row 80 and change the 1 to a 2 if they match or leave it the number that is already there if they did not match. Can you help?
From rows 1 to 75, create a dummy column with the formula e&"/"&f.
starting row 80 and using columns e and f, fill out all possible entry combinations for columns e and f.
then, for each possible combination, use the formula countif(dummy column range,e&" "&f)
note that the ("/") is put up to separate values of e and f.
Look into the =SUMIF function, it sounds like this may be what you are looking for.
Hope this helps!
154 views
Usually answered in minutes!
i WANT TO KNOW NOT EQAUL TOO FORMULA.
×