Horizontal Bar Chart - Dynamic?

Jeeps, this one has me stumped. But you can stop tearing your hair out.

For some reason, Excel 2007 does not update a formula like

=SUMPRODUCT(--(Outcome=$O$11),--(position="last"),--(count=M12))

Not when you hit F9, anyway, only when you edit the formula and hit enter.

But it does calculate with the syntax

=SUMPRODUCT((Outcome=$O$11)*(position="last")*(count=M12))

Also, since Excel 2007 has the new sumifs and countifs formulae, I could use

=COUNTIFS(Outcome,$N$11,position,"last",count,M12)

I used the Countifs version in the WIN column and the SUMPRODUCT in the Loss column, so you can enjoy both.

The links are cleared, the chart updates, --- as far as I'm concerned, this is now working fine.

I'll never touch this file with XL 2003 again, promise!

Hope that solves your immediate problem. Cheers! Sleep well!