Home » Forums » Open Source Learning Center » Question and Answer

SUMIFS function

Submitted by zoller.robert on 7 October, 2014 - 13:03

Hi All,
There is a master xlsx in where we use SUMIFS function. The function gets data from other datasheets all saved in the same subdirectory.
If we do not open all source data sheet regardless we refresh data or not there is the same message in every cell (in we use SUMIFS): #value!
In the cells where we use VLOOKUP function there is no problem.
What would be the fault? How could we correct the fault?
Thanks for your help in advance.
Regards,
Robert Zoller

‹ Hide/Unhide specific cells using data validation list import Multiple Text Files into one EXCEL worksheet ›
»

SUMIFS

Submitted by leigh3980 on 16 November, 2014 - 15:33.

Hi Robert,
that generally means that you have part of your code wrong. Can you upload a sample of what you are trying to do?

thanks

Leigh

»

SUMIFS

Submitted by leigh3980 on 16 November, 2014 - 15:33.

Hi Robert,
that generally means that you have part of your code wrong. Can you upload a sample of what you are trying to do?

thanks

Leigh

»

Mail

Submitted by zoller.robert on 17 November, 2014 - 08:52.

To leigh3980
Thanks for your answer. Pls send a mail to may mail address of zoller.robert@euroone.hu and I try to send you the xlsx file
Regards,
Robert Zoller

»