What does your data look like?

I would expect =AND(AO8,AP8<5) to be returning TRUE or FALSE, not 0, 1

If so try

=SUMIF(QUEST7,TRUE,North)

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Trevor Aiston" wrote:

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