I'm trying to find the difference of two columns of data (only on the
subtotal row) created with a pivot table, instead of the "total" that the
table gives me. I thought I would be able to put in an "if" statement,
sopmething to the effect of "if column B includes the text "total", then
subtract column E from column F. I don't want it on all rows, only the
subtotal rows, which all include the text "total".

Does anyone have an idea on how I can accomplish this?

Thanks!
Cathy