Hi bionicle,Hi All,
have a question for you, if I have a list of dates in the format of 05/01/2016 but want to return a sum value against all the dates listed as January how do I do it?
Hi All,
have a question for you, if I have a list of dates in the format of 05/01/2016 but want to return a sum value against all the dates listed as January how do I do it?
Hi bionicle,
Assuming that your dates and in column A and the values are in column B you could try this:
=SUMIFS(B1:B100,A1:A100,">="&DATE(2016,1,1),A1:A100,"<="&DATE(2016,1,31))
Alternatively, assuming your dates are in row 1 going across and your values are in row 2 then you could try this:
=SUMIFS(A2:CV2,A1:CV1,">="&DATE(2016,1,1),A1:CV1,"<="&DATE(2016,1,31))
You'd probably want to change this to a SUMPRODUCT as follows:Just noticed something, on my spread sheet I have multiple years; what if I only want to look at the month rather than specific years i.e all dates say within January rather than just 2016?
also how would I get it to look at a third column (Q) so it only summed against the word WON