I have lots of groups with subtotals. I need to multiply the various
subtotals by a factor (factors change depending on the group) that's in its
own column and then get the product (which needs to be an even number
(rounded up).

Those products need to be added to the subtotal - which should now give a
new subtotal for the group.

Then those new group subtotals need to be added to get a Total.

All I get are "0" when I try to do this. And I'm under a deadline.
Is there anyone out there who can help???? Thanks.

url:http://www.ureader.com/gp/1027-1.aspx

It sounds as if you are tring to do this in the same cell as the SUBTOTAL()
which would give you a circular fererence.

In another cell with the SUBTOTAL() in - say C25 try:

=CEILING(C25*F5,2)


--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk


"Arthur Michaels" <nergetit@yeeha.com> wrote in message
news:9b8af245aea94eaa9bde5ebb8af14377@newspe.com.. .
>I have lots of groups with subtotals. I need to multiply the various
> subtotals by a factor (factors change depending on the group) that's in
> its
> own column and then get the product (which needs to be an even number
> (rounded up).
>
> Those products need to be added to the subtotal - which should now give a
> new subtotal for the group.
>
> Then those new group subtotals need to be added to get a Total.
>
> All I get are "0" when I try to do this. And I'm under a deadline.
> Is there anyone out there who can help???? Thanks.
>
> url:http://www.ureader.com/gp/1027-1.aspx
>