Added to the above.

I have tried the following:
=SUMIF(fce1A, TRUE, SpEE)
it seems to work as does...
=SUMIF(month, "Mar 2006", SpEE)

Any thoughts?
Perhaps I should just write a custom function? I've actually tried that but
it's not working properly yet.

"Question" wrote:

I have seen the answers to similar questions which suggest the use of
SUMPRODUCT. I have also seen mention that this works for exact and equal
ranges, but i need to do this for columns, because i will be continuously
adding to the ranges.

My columns are named ranges (month, fce1A, SpEE). Here is the sumif
statement.

=SUMIF(AND(month = "Mar 2006", fce1A = true),true,SpEE)