|
|
#1
02-01-2018, 06:29 AM
|
|||
|
|||
Formula Help Needed
Hi All
I have the following formula on a worksheet called "Metrics" however it is not calculating anything: SUMPRODUCT((Risks!K:K>=Y3)*(Risks!K:K<=Z3)) When I put all the values on the same sheet it work fine. Any help appreciated. Thanks Tony 
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Formula needed; I'm helpless | Ylli | Excel | 10 | 12-13-2017 04:06 AM |
 Help needed with IF formula with a Vlookup
|
jonnie_rc | Excel | 6 | 08-31-2017 01:27 PM |
| Complicated Formula Needed | midgetmogalle | Excel | 14 | 01-29-2014 10:26 AM |
|
Formula help needed
|
Cosmo | Excel | 1 | 08-23-2012 11:50 AM |
| Excel formula needed. | Rod | Excel | 1 | 08-03-2009 06:55 AM |
Windows 10 
Office 2016
Threaded Mode