|
|
#2
10-03-2017, 11:02 PM
|
|||
|
|||
In your Excel version, you can use SUMIFS (NB! SUMIFS, not SUMIF) function instead of array formula - try this.
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
 How do I make a checkbox or dropdown item reference data in that specific section of the data array?
|
dhare | Excel Programming | 2 | 02-24-2016 12:36 PM |
| Data connection from Excel to Sharepoint not working | GraemeW | Excel | 0 | 01-16-2016 04:31 PM |
| MS Excel - SQL Data Query Connection to MS Project - Resource Displayed in Multiple lines not in one | AKent | Excel | 3 | 08-26-2015 01:34 PM |
| Excel 2007 security alert - data connection message every time? | michael.monaco | Excel | 0 | 12-20-2012 07:47 AM |
| How to count the frequency of data and also tally value from an array of Excel record | KIM SOLIS | Excel | 5 | 09-07-2011 09:01 AM |
Windows 8 
Office 2016
Threaded Mode