data from pivot table

  1. A

    Problem with COUNTIFS with multiple criteria

    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,"<=" &...
  2. M

    Formula from pivot table data xl 2000-2003

    HEllo:) 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...

Some videos you may like

This Week's Hot Topics