Thread: Data connection problem excel/sharepoint using an SUMIF array
View Single Post
 
Old 10-03-2017, 11:02 PM
ArviLaanemets ArviLaanemets is offline Windows 8 Office 2016
Expert
  
Join Date: May 2017
Posts: 949
ArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant futureArviLaanemets has a brilliant future
Default
In your Excel version, you can use SUMIFS (NB! SUMIFS, not SUMIF) function instead of array formula - try this.
Reply With Quote