First off I am pretty sure that the COUNTIFS formula is not available in Docs which is a real shame because I use it all the time for multiple reports. Basically, I have a grid that is updated every day by a department. We are trying to track certain performance stats. Anyway, the only way I have been able to do this is by creating multiple pivot tables and then to have my formulas reference them using INDEX and MATCH. The problem I have is that this is just too many tabs and it gets confusing for other users. I need this too be very simple. On Excel I have a "Start Date" cell, an "End Date" cell, an "Employee" cell and so on. The user simply has to fill these in to get any statistics he needs. On Docs they have to go to each Pivot Table, put in the date filters, make sure they all have the same date range and only then can they get, for instance, last weeks stats. I keep the date filters out because it updates real time when they are not there and that is nice to have. I would like to keep that. In other words, if the start and end date cells are left empty, it will just show the stats month to date as these grids are all done monthly. Here is an example of one of the formulas I have to use. Again, I would prefer that all formulas would reference the main raw data table and not a pivot but I have not found an efficient way to do that yet.

=IFERROR(INDEX(PreCallPivot!$A$1:$Z$98,MATCH("Connectivity Available",PreCallPivot!$A:$A,0),MATCH(B$1,PreCallPivot!$1:$1,0)),0)+IFERROR(INDEX(PreCallPivot!$A$1:$Z$98,MATCH("No Connectivity Available",PreCallPivot!$A:$A,0),MATCH(B$1,PreCallPivot!$1:$1,0)),0)+IFERROR(INDEX(PreCallPivot!$A$1:$Z$98,MATCH("Follow Up-Getting IP Within 7 Days",PreCallPivot!$A:$A,0),MATCH(B$1,PreCallPivot!$1:$1,0)),0)-IFERROR(INDEX(PrecallPivot!$A$1:$Z$98,MATCH("Do Not Contact-Not Completed",PreCallPivot!$A:$A,0),(MATCH(B$1,PreCallPivot!$1:$1,0)),0))

B1 is the employee's name.

I know there has to be an easier way to do this. If more information is needed, please let me know and I can provide whatever will help. Thanks in advance for any assistance.