Dan,

I'm not sure I understand this but maybe your using something like

=SUM(A1:A40)*SUM(B1:B40)

and what you should be using is

=SUMPRODUCT(A1:A40*B1:B40)

Mike

"Dan K" wrote:

I had created a formula of (column 1) * (column 2) and the results are
correct. The problem that I am having is that the grand total does not sum
the results. The grand total takes the (sum of colum 1 * the sum of column 2)

Is there a way to sum the formula total in the pivot table?