Formula

[Rae]

Cust# Sept.08 Sept.07 Act Diff Pct Diff bills bills
29806 $1,838.70 $1,219.45 619.25 51 16 10
I need to be able to create a formula stating if the Pct Diff is over 5%
what is the pct of Sept 08($1838.70) totals.

 

[Carl Witthoft]

Cust# Sept.08 Sept.07 Act Diff Pct Diff bills bills
29806 $1,838.70 $1,219.45 619.25 51 16 10
I need to be able to create a formula stating if the Pct Diff is over 5%
what is the pct of Sept 08($1838.70) totals.

Start by parsing your example text better.

Assuming you posted two rows, the top one of which is the header,
then

=if(E2>0.05,C2/B2,"")

Where col E is PctDif, C2 is Sept 07, B2 is Sept 08

That is a row-by-row calculation.
If you want a sum of all rows which meet that criterion, look up SUMIF