Unable to extract Data

[Skybluekid]

Hi All,

I have three tables from different worksheets, which I have I merged into one Query, within Power Query. I have then placed the merged table onto a worksheet. Within the merged sheet I have a costs coulmn.

When I have referenced the merged table, within formulas specifically SUMIF or SUMIFS, the formula is not working, however when I use COUNTIF or COUNTIFS it brings back the correct result. What could be the issue?

Thanks in Advance.

 

[Ron Coderre]

You'd need to clarify "not working"...Returns zero? Returns incorrect results? Errors?

Apart from that, the issue is probably related to the data and the match parameters. (extra spaces? numbers vs. text?)

 

[Skybluekid]

Sorry, yes it does return Zeros. I have tried different permutations with the same result

 

[Ron Coderre]

OK....How about posting some of the formulas you've tried...and maybe some sample data?

 

[Skybluekid]

I have solved the issue, I was using the wrong data format in the three feeding tables. Once adjusted, it works.