Question about Microsoft Excel for PC
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
a 6ya Technician 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 repair professionals here in the US.
click here to Talk to a Technician (only for users in the US for now) and get all the help you need.
Posted on Jan 02, 2017
Tips for a great answer:
Feb 24, 2013 | Office Equipment & Supplies
Jun 13, 2011 | Casio FX991MS Scientific Calculator
Apr 28, 2011 | Texas Instruments TI-15 Explorer...
Aug 04, 2010 | Casio FX-115ES Scientific Calculator
Apr 13, 2010 | Texas Instruments TI-89 Calculator
Mar 25, 2010 | Cell Phones
Jan 28, 2010 | Texas Instruments TI-Nspire Graphic...
Dec 07, 2009 | Texas Instruments TI-30XA Calculator
Mar 21, 2009 | Samsung SPH-M300 Cellular Phone
Nov 16, 2008 | Computers & Internet
Jan 28, 2016 | Microsoft Excel for PC
Dec 12, 2013 | Microsoft Excel for PC
Jul 23, 2013 | Microsoft Excel for PC
130 people viewed this question
Usually answered in minutes!
Step 2: Please assign your manual to a product: