|
|
#5
02-11-2018, 10:33 AM
|
|||
|
|||
Quote:
It will be easier if you don't mind to open up my example sheet attached. In the first tab, the formula worked perfectly with the right result. In the second tab, when I took out the blank column and changed the formula. The result failed. It maybe a bit hard to put this into words. Really appreciate your help. Thank you 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 COUNTIFS with two criteria returns wrong result
|
Ted C | Excel | 3 | 01-19-2016 07:50 AM |
|
formula, 2 criteria, one result
|
cjdstephenson | Excel | 4 | 06-02-2015 09:17 PM |
|
Formula returns wrong value
|
bobsone1 | Excel | 2 | 08-19-2014 12:12 AM |
| IF formula returns wrong result | mashley | Excel | 3 | 09-07-2012 07:03 AM |
| IF formula returns TRUE instead of evaluating COUNTIF | ColinC | Excel | 4 | 12-28-2011 08:21 AM |
Windows 8 
Office 2010 32bit
Threaded Mode