Problem with COUNTIFS with multiple criteria

[arnorian]

Hi,
I am having a slight gllitch with COUNTIFS and can't seem to locate the error. There are total of 10 transactions that all should fall within the range but I'm getting an output of 141!! (idk how that is happening)

=COUNTIFS('Sheet1'!G2:G5894,"=" & 'Pivot Table'!A4,'Sheet1'!J2:J5894,"<=" & 'Pivot Table'!L4,'Sheet1'!J2:J5894,">=" & 'Pivot Table'!M4)

In my sheet1 I have all the individual transaction for each SKU in Column G and their respective unit prices in Column J.
In the sheet Pivot Table Column A has all the SKUs listed, Column L and M have range of prices that I want to compare to column J in Sheet1

Ex:
Column A SKU: Server123 and there's 10 of them
Column L: $414
Column M: $306
Column J prices for all transaction: all 10 are within the range
Output should be 10, but I'm getting 14

Please Help I'm going

 

[AlphaFrog]

If this is accurate:

Column A SKU: Server123 and there's 10 of them

Then just this should return 10
=COUNTIFS('Sheet1'!G2:G5894,"=" & 'Pivot Table'!A4)

So my guess is A4 or the column G data is the issue.

 

[arnorian]

I thought originally the same since A4 is from Pivot Table. But I then copied/pasted those values into a new column as values and same problem persists.
checked
I filtered and double column G to make sure for the first et that there are only 10 transactions and it checks. I'm at my wit's end

 

[AlphaFrog]

Can you upload your workbook (first sanitize it of any sensitive data) to a file share site and post the link here?

 

[arnorian]

I figured it out guys. Apparently it though I had filtered year 2013 out it was still pulling from it. Once i deleted the data and just left 2012. It all worked. I thought I was going crazy.

Thanks for all the help and feedback