"leapyleigh" wrote
in message ...

Hello !!

HELP!!

I have a report I need to finish by the end of the week and I am
dealing with hundreds of rows.

I need to be able to add up the total of every 4th row only.

I cannot for the life of me figure out what forumla I need to use.

Any help would be greatly appreciated!!

One way is to use a formula like =IF(MOD(ROW(),4)=1,A1,"") and total that
column.

There will doubtless be clever things with SUMIF and SUMPRODUCT that other
contributors will be able to suggest.
--
David Biddulph