2D sumif loop?
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.
|