I have a range of cells, E64:P75, which need to be summed. Each column of
cells in this range (i.e., E64:E75, F64:F75, etc.) is categorized as either
"project" or "BAU"

I want two sums calculated from this range: total project and total BAU.
Here's the tricky part: the categorization of a particular column in this
range as either "project" or "BAU" is in row 59.

How can I do this? I can, in theory do the sum by color routine, as
conditional formatting has been applied to this range based on the
categorizations explained above. However, I would like to avoid VBA, as my
boss seems suspicious of it.

Any thoughts on how to do this with formulas?

Thanks,

Dave
--
Brevity is the soul of wit.