How about a nice, simple, single formula of:

=SUMPRODUCT((M5:M1000=C4)*(B5:J1000))

--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------


"Aladin Akyurek" wrote in message
...
Why not create a total per record in column N, by means of:

=SUM(B5:J5)

and invoking a simple and fast SumIf formula:

=SUMIF(jan!$M$5:$M$1000,"="&C4,jan!$N$5:$N$1000)

Roger Govier wrote:
Hi

Try the array entered formula
{=SUM(IF($M$5:$M$1000=C4,$B$5:$J$1000)}

Use Ctrl+Shift+Enter to commit or amend the formula.