Conditional sum result not shown

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have the formula
SUM(IF(Logs!$E$3:$E$1000=CODES!$F$2,IF(Logs!$F$3:$F$1000=CODES!$A$2,1,0),0)
used to get a count of the number of logs raised by F2 with status A2

The formulae results are correct when viewed in the forumla inspector, and react according to any changes
The problem is, the cell shows a zero - always

There's nothing other than what's above in the formula
Re-calculation is not the problem, as other formula are updating happily on the same data
The original came from the conditional sum wizard, but I edited it to fetch the constants from datafields rather than using strings
I also moved it to another sheet as a string copy-paste, checking the references
I've checked all the things I can think of - format, protection, extra letters after the formula

help
 
Hoggle

Your formula is an array formula and must be entered
with <Shift><Ctrl><Enter>, also if edited later. If done
correctly, Excel will display the formula in the formula
bar enclosed in curly brackets { }. Don't enter these
brackets yourself. They are Excel's way of showing,
that the formula is treated as an array formula.

--
Best Regards
Leo Heuser

Followup to newsgroup only please.

Hoggle said:
I have the formula
SUM(IF(Logs!$E$3:$E$1000=CODES!$F$2,IF(Logs!$F$3:$F$1000=CODES!$A$2,1,0),0))
used to get a count of the number of logs raised by F2 with status A2.

The formulae results are correct when viewed in the forumla inspector, and
Click to expand...
react according to any changes.
The problem is, the cell shows a zero - always.

There's nothing other than what's above in the formula.
Re-calculation is not the problem, as other formula are updating happily on the same data.
The original came from the conditional sum wizard, but I edited it to
Click to expand...
fetch the constants from datafields rather than using strings.
 
Back
Top