I
Ian
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="Jan",(d:d))))
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="Jan",(d:d))))