Solved Cannot find error in formula

November 5, 2017 at 01:58:05
Specs: Windows 10
Pls hep me finding error in the following formula in office 2007: its giving a #value error:

=SUMIFS(GL!$M$8:$M$4300,'Main BS'!$E8,GL!$D$8:$D$4300,'Main BS'!G$4,GL!$A$8:$A$4300)


See More: Cannot find error in formula

Reply ↓  Report •

#1
November 5, 2017 at 02:53:36
Check your data.
Excel displays the #VALUE! error when a formula has the wrong type of argument.

Are you dealing with Dates by any chance?

Look here for more info:

https://support.office.com/en-us/ar...

MIKE

http://www.skeptic.com/


Reply ↓  Report •

#2
November 5, 2017 at 04:53:26
✔ Best Answer
The syntax for SUMIFS is:

SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)

It looks to me like you have your criteria_ranges and criterias reversed.

You have:

sum_range:            GL!$M$8:$M$4300
criteria_range1:      'Main BS'!$E8
criteria1:            GL!$D$8:$D$4300
criteria_range2:      'Main BS'!G$4
criteria2:            GL!$A$8:$A$4300

You are trying to "match" a range of cells e.g. GL!$D$8:$D$4300 to a single cell e.g.'Main BS'!$E8. It needs to be the other way around.

How To Post Data or Code ---> Click Here Before Posting Data or VBA Code


Reply ↓  Report •
Related Solutions


Ask Question