|
|
#9
01-18-2016, 10:31 AM
|
|||
|
|||
is this correct? I get an answer of 0
With Range("AE2") .Value2 = Application.CountIfs(Range("N:N"), "4", Range("G:G"), "OPEN", Range("O:O"), ">0") .NumberFormat = "#,##0" End With But with this in a cell I get an answer of 4 =COUNTIFS(G:G,"OPEN",N:N,"4",O:O,">0") 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Using Right and Len formulas together | PDGood | Excel | 4 | 11-20-2015 06:50 AM |
| formulas | MSA5455 | Excel | 3 | 12-19-2014 01:50 AM |
| Help with IF or ELSE Formulas | tsaladyga | Excel | 4 | 07-23-2014 09:04 AM |
| Need help with formulas please | paul_pearson | Excel | 0 | 03-20-2013 06:51 AM |
 IF Formulas
|
mizzamzz | Excel | 1 | 07-08-2010 02:32 AM |
Windows 7 64bit 
Office 2010 64bit
Threaded Mode