I am trying to use a sumif function on a range of cells (named QUEST7) which
has calculated cells
Each calculated cell is uses the AND function
CELL AQ8 '=AND(AO8,AP8<5)'

The sum function is used to calculate the named range of cells
=SUMIF(QUEST7,1,North). North being a named range
But it returns 0 (actual result should be 12). I can get round it by
adding another column with a numeric result based on the AND function
column(=IF(AQ8=TRUE,1,0)). But I thought in excel TRUE=1, FALSE=0

Will sumif not sum 'TRUE' results?
Trevor