Hi Max

You are very kind :-)

Yes, you are right. It should have been a semicolon.

Thanks!

Regards
LeoH


"Max" skrev i en meddelelse
...
Hi Leo,

Nice to see you around. It's much neater,
but perhaps there was a typo? Should it be:
=SUM(COUNTIF(OFFSET(G$1,{0,13,25,37},,12),$AN$1-{0;0.5}))
(with the semicolon instead of the comma in " {0;0.5} ")
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Leo Heuser" wrote in message
...
Hi Pete

One way:

=SUM(COUNTIF(OFFSET(G$1,{0,13,25,37},,12),$AN$1-{0,0.5}))

--
Best Regards
Leo Heuser

Followup to newsgroup only please.