Okay I ended up using the first one and it worked perfectly. I have a
second totalling column on the end right next to the cell where I put
this formula. I assumed it would apply exactly the same, but it
definately does not.
I need to total every column cell starting at F3:HB3 also. I don't
understand why this wouldn't work exactly the same. If you have an
answer, I would definately appreciate it.
-Ben Thieson
Biff Wrote:
Hi!
Try this:
=SUMPRODUCT(--(MOD(COLUMN(E3:HA3),3)=2),E3:HA3)
If you might ever insert new columns before the start of the range:
=SUMPRODUCT(--(MOD(COLUMN(E3:HA3)-COLUMN(E3),3)=0),E3:HA)
Biff
"bthieson" wrote
in
message ...
I have quite a large excel sheet with about 210 columns. I need a sum
at
the end of each row for every third cell. I have tried a couple
different formulas that should work, but they always end up adding
other values in for some reason. The cells I need added go like so:
E3,H3......HA3. I'm sure a few of you out there have dealt with this
before. If you have a resolution, I would definately appreciate your
response.
--
bthieson
------------------------------------------------------------------------
bthieson's Profile:
http://www.excelforum.com/member.php...o&userid=34357
View this thread:
http://www.excelforum.com/showthread...hreadid=541295
--
bthieson
------------------------------------------------------------------------
bthieson's Profile:
http://www.excelforum.com/member.php...o&userid=34357
View this thread:
http://www.excelforum.com/showthread...hreadid=541295