Ken, it works great. Thanks a bunch.

GB

"Ken Johnson" wrote:


Oops!
That only gives the January figures. Need to get rid of the $'s in the
third array argument column addresses...

=SUMPRODUCT(('Input Data'!$B$2:$B$10=$A$1)*('Input
Data'!$C$2:$C$10=$B1)*('Input Data'!D$2:D$10))

Ken Johnson