SUMIFS formula, reading text

[tamaradinneen]

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 ar
within a certain month, and if they match text in a drop-down list i
column D, and if they have a number entry in column R. My formula thu
far is
=SUMIFS(L69:L92;K69:K92;">="&DATE(2012;7;1);K69:K92;"<="&DATE(2012;7;31);D6994;"P&A";R69:R92;"<>")
This returns #VALUE! error, and I don't know why. I checked each part o
the equation, and it seems the error lies with the text read (column D
D6994;"P&A").
Can anyone tell me how to fix this? I have also tried to replace the
text with other text, and it still doesn't work, so I am pretty sur
it's this section of the formula that is causing the problem.
Many thanks in advance,
Tamar

 

[joeu2004]

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

You have a typo: the range D6994 should be D6992.