MacroChaotic wrote...
Looks like CountIfs() and the pivot table count functionality in the data
section are returning different values. Same with SumIfs() and the sum
functionality. Using Excel2007 (v12.0.4518.1014).
....

You're wasting your time asking this in this newsgroup. Ask in an Excel
newsgroup. I'm crossposting this response to
microsoft.public.excel.worksheet.functions.

Any constructuve thoughts appreciated.

Show us the formulas you're using and explain the pivot table layout.
No details from you, no possible way to provide any meaningful response
from the rest of us.