Array Formula Results & Value Issue

[Killsek]

Hello,

I am stuck on a problem I am having with an Array formula's results. I have a Data sheet which has 4 columns I am using to get the data from and populated on a JAN sheet. All is working but even the the value displays a number it doesn't act like a number. I have verified all the numbers in the DATA sheet are numbers but the formula produces a non number value even though it displays the correct number.

The array formula that I am using to populate the fields is: {=IFERROR(INDEX((DATA!$G$2:$G$20 & DATA!$H$2:$H$20), SMALL(IF(N$4=DATA!$A$2:$A$20, ROW(DATA!$A$2:$A$20)-ROW(DATA!$A$2)+1), ROW(1:1))),"" )}

One of the issues I am having is on a Summary sheet I am trying to do is look up a certain field on the JAN tab and give the SUM of all it finds titled with the name : =IFERROR(SUMIF(Jan!$B$4:$O$69,$A4,Jan!$C$4:$O$69),"")
In this case A4 is text "Wages and Salaries"

How it works is the Jan sheet is a Calendar and each day/box has 10 rows and 2 columns. the first column pulls the category from the DATA sheet based on the days date the populates the fields within that day with what it found and the next column is the credit or debit from the DATA sheet.

Is there an easier way to do this; Or have I really made a mountain out of a mole hill? Any help is appreciated.!

 

[bebo021999]

With this:
DATA!$G$2:$G$20 & DATA!$H$2:$H$20
the value could be: 200 & "" = "200"
but its text string followed by a "" , not value

Why not try:
DATA!$G$2:$G$20 + DATA!$H$2:$H$20

???

 

[Killsek]

With this:
DATA!$G$2:$G$20 & DATA!$H$2:$H$20
the value could be: 200 & "" = "200"
but its text string followed by a "" , not value

Why not try:
DATA!$G$2:$G$20 + DATA!$H$2:$H$20

???

Dang, you're awesome; thank you so much....can't believe it was that simple