Hi, I am new to the forum, so would really appreciate a response.
I need to create a formula to sum the values in a column (L) if they are within a certain month, and if they match text in a drop-down list in column D, and if they have a number entry in column R. My formula thus far is
=SUMIFS(L69:L92;K69:K92;"="&DATE(2012;7;1);K69:K9 2;"<="&DATE(2012;7;31);D69:D94;"P&A";R69:R92;"< ")
This returns #VALUE! error, and I don't know why. I checked each part of the equation, and it seems the error lies with the text read (column D - D69:D94;"P&A").
Can anyone tell me how to fix this? I have also tried to replace the D text with other text, and it still doesn't work, so I am pretty sure it's this section of the formula that is causing the problem.
Many thanks in advance,
Tamara

"tamaradinneen" wrote:
=SUMIFS(L69:L92;K69:K92;"="&DATE(2012;7;1);K69:K9 2;"<="&DATE
(2012;7;31);D69:D94;"P&A";R69:R92;"<")
This returns #VALUE! error, and I don't know why.

You have a typo: the range D69:D94 should be D69:D92.