You can use the sumif in an array, use the formula below but hold in
ctrl+shift when you press enter.

=SUM(IF(A34:A39="Smith",IF(B34:B39="London",IF(C34 :C39="Jan",(D34:D39)))))


"Ian" wrote:

I'm trying to determine a sum via a number of SUMIF's, and am failing badly !

To explain, I have 4 columns with data in - Names, Town, Month, Sales. I
need to show the total Sales number where the Names and Town and Month are
the same.

eg
=sumif(a:a="Smith",sumif(b:b="London",sumif(c:c="J an",(d:d))))

--
Many thanks

Ian