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,"<=" &...
I've been trying to find information about how to calculate a formula using pivot table data.
Here is the pivot table:
<TABLE style="WIDTH: 260pt; BORDER-COLLAPSE: collapse" cellSpacing=0 cellPadding=0 width=347 border=0 x:str><COLGROUP><COL style="WIDTH: 104pt; mso-width-source...