Hi,

Not sure of your data, but if it is in the format of your second post,
Hol(s) 8.00 9.75 9.00 Hol(c) 0.00 10.00 9.25 9.00 8.25
then that can be totalled using (your data in A8 to J8)

=IF(ISERROR(MATCH("Hol(c)",A8:J8,0)),SUM(A8:J8),SU M(A8:
(OFFSET(A8,0,L8,1,1))))
and in the next column
=IF(ISERROR(MATCH("Hol(c)",A8:J8,0)),"",SUM((OFFSE T(A8,0,L8,1,1)
:J8)))

with, in column L
=MATCH("Hol(c)",A8:J8)-1

the first column will total up all hols if no Hol(c) exists, or the
hours to the left of that word.
the second column will total any hours after finding Hol(c) or be
blank.

Also, a sum can be =Sum(B8,D8,F8,H8) etc.

btw, well spotted Bernard, I read as far as "How do I sum excluding
some columns" and should have read on.
watch for spaces inserted to prevent smiley faces.


HappyTrucker Wrote:
I can't use SUM unfortunately, because I needed to SUM alternate columns
B3,D3,F3 and C3,E3,G3 etc), not the whole row.


--
Bryan Hessey
------------------------------------------------------------------------
Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059
View this thread: http://www.excelforum.com/showthread...hreadid=395644