|
|
#4
10-04-2017, 03:51 PM
|
|||
|
|||
@ArviLaanements:
When using sumifs I get all the rows containing the data from F5, B1 and B2. But there are some rows with the same date that must be considered as 1. i.e. row 1 19JAN17 row 2 20JAN17 row 3 20JAN17 With sumifs I get 3, but it must be 2 @Debaser when manually exporting the data out of my sharepoint to excel and than copy, paste it into my calculating file (on tab data) there are no problems. When using the dataconnection refresh function (importing the same sharepoint columns with the same data type) the formula returns #NA 
|
|
|
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 7 64bit 
Office 2013
Threaded Mode