I'm not sure what I need here, but if you have any suggestions - I'd very much appreciate them!
I'm using a list and filtering out records (using Auto Filter).
So my list starts out looking something like this:
Date Month Type Doc #
18-May May PTW 1290683
18-May May PTW 1290686
18-May May LB 1
18-May May PTW 1290686
18-May May LB 9
18-May May PTW 1283063
18-May May PTW 1290683
20-May May PTW 1293386
When I filter out the 'Type' column to see only 'LB' documents;
I'll see only the entries for 'LB'. (in the above example,
the number of 'LB' documents would be 2).
Above this list I would like the number of LB documents (2) displayed - something like this.
Number of LB Documents: 2
No problem so far - I use the SUBTOTAL function.
However!
There is another option in this column - 'PTW'. And I'd like THAT to be displayed as well, if the list is filtered out for 'PTW' entries.
So my display would look something like:
Number of LB Documents: 2
Number of PTW Documents:
What I want is to display an answer if LB is selected (and thus display nothing for PTW documents). But, if PTW is selected I want that to display, but nothing for LB documents. like this -
Number of LB Documents:
Number of PTW Documents: 6
So I tried this calculation:
I used OFFSET to determine the entry in cell C28 (when filtered).=IF(OFFSET(C27,1,0)="PTW",SUBTOTAL(3,PTWList)," ") &IF(OFFSET(C27,1,0)="LB",SUBTOTAL(3,PWTList)," ")
If the entry is PTW, do the subtotal. PTWList is the named range of cells under the column heading in cell C27.
vice versa if it the entry is LB.
Unfortunately, it ain't working!
It just adds up, no matter whether PTW or LB is selected.
Am I simply using the wrong function; or is this a job for ...
VB Man!
Can anyone help me?
Thank you SO much!!
__________________
Lori Hughes