At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.

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.

- If you need clarification, ask it in the comment box above.

- Better answers use proper spelling and grammar.

- Provide details, support with references or personal experience.

Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.

Tip: The max point reward for answering a question is 15.

i WANT TO KNOW NOT EQAUL TOO FORMULA.

×