Sum formula help

[erniepoe]

Hi all,

So I'm trying to add the values of columns N and U when both columns O and V have a date value from July, 2011.


I have the following CSE formula, but it's still resulting in the #Value error. I think that I'm close, but if anyone could nudge me in the correct direction, I'd be most appreciative.



=SUM((O1:O81>=7/1/11)*(O1:O81<7/31/11)*(V1:V81>=7/1/11)*(V1:V81<7/31/11)*(N1:N81)*(U1:U81))

 

[Jonmo1]

Do you want it to sum BOTH N and U if Either O or V are in July?
Or do you want it to sum (N if O is in July) + (U if V is in July)?

 

[Jonmo1]

If you want
sum BOTH N and U if Either O or V are in July?

=SUMPRODUCT(((TEXT(O1:O81,"mmmyyyy")="Jul2011")+(TEXT(V1:V81,"mmmyyyy")="Jul2011")>0)*(N1:N81+U1:U81))

If you want
sum (N if O is in July) + (U if V is in July)?

=SUMPRODUCT(((TEXT(O1:O81,"mmmyyyy")="Jul2011")*(N1:N81))+((TEXT(V1:V81,"mmmyyyy")="Jul2011")*(U1:U81)))