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.
Posted on Nov 18, 2008
Look into the =SUMIF function, it sounds like this may be what you are looking for.
Hope this helps!
Posted on May 09, 2008
Hi,
a 6ya expert can help you resolve that issue over the phone in a minute or two.
best thing about this new service is that you are never placed on hold and get to talk to real repairmen in the US.
the service is completely free and covers almost anything you can think of (from cars to computers, handyman, and even drones).
click here to download the app (for users in the US for now) and get all the help you need.
goodluck!
Posted on Jan 02, 2017
Jan 19, 2016 | Computers & Internet
Apr 09, 2014 | Microsoft Excel for PC
Jun 04, 2011 | Microsoft Excel for PC
Dec 15, 2010 | Microsoft Office Excel 2003 for PC
Oct 29, 2009 | Microsoft Excel for PC
Oct 25, 2009 | Microsoft Excel for PC
Jun 18, 2009 | Microsoft Excel for PC
Nov 20, 2008 | Microsoft Excel for PC
Oct 16, 2008 | Microsoft Excel for PC
Apr 04, 2008 | Microsoft Excel for PC
Jan 28, 2016 | Microsoft Excel for PC
126 people viewed this question
Usually answered in minutes!
i WANT TO KNOW NOT EQAUL TOO FORMULA.
×