Conditional Sum Wizard woes

  • Thread starter Thread starter Ian
  • Start date Start date
I

Ian

If I use the wizard it produces a working cell with my answer. The formula
it creates is:
{=SUM(IF(Bankings!$A$7:$A$42>=DATEVALUE("04/08/2004"),IF(Bankings!$A$7:$A$42<DATEVALUE("04/09/2004"),Bankings!$D$7:$D$42,0),0))}
Note the curly bracket which show up if I click on the cell it populated.
If put the cursor into the edit line but then press return without making
any change I get #VALUE!. Examining the cell again shows the curly brackets
gone. The error tip says "a value used in the formula is of the wrong
datatype".

What on earth is going on?
Ian
PS UK so dd/mm/yyyy form of date if relevant.
 
Those curly braces mean it is an array formula and CANNOT just be put into the
formula manually. You need to enter the formula using CTRL+SHIFT+ENTER.
 
Wow, that is a bit obscure. I will go and play. How was I supposed to guess
that Microsoft!?
 
Back
Top