Why error: the use of OR logical operator in the SUM function

**BNCOXUK** · 07-25-2012, 06:52 AM

Hi, I want to sum the positive values in column B, which satisfies the condition: date between 29/02/2012 and 31/05/2012. I used the OR function as below, but this always resulted in an error. I am wondering the problem may be due to the use of OR operator in the SUM() function.

={SUM(IF(OR((A1:A6<C2),(A1:A6>C1)),"",IF(B1:B6>0,B1:B6,0))}

A B C
30/06/2012 8 31/05/2012
31/05/2012 4 29/02/2012
30/04/2012 3
31/03/2012 -2
29/02/2012 0
31/01/2012 5

**vikas.bhandari** · 07-25-2012, 07:12 AM

Error is coming because of the string(double quotes) you are using. It cannot sum up the space. Use this :

Formula:

Please Login or Register  to view this content.

**BNCOXUK** · 07-25-2012, 09:18 AM

Just don't understand the solution

**vikas.bhandari** · 07-25-2012, 09:32 AM

Ok! You used "" in your formula. So the double quotes are considered as string. Your formula was unable to add it because it was finding a string for summing up. For example, if you enter a formula in a cell in excel :

Formula:

Please Login or Register  to view this content.

It doesn't give you 32 as a result, but an error. Excel cannot add "". In your formula, you were providing "" to be summed up. That is why the error.

Thanks,
Vikas B