Hi Bob,

There appears to have been a slight hiccup in the postings, however

K15 K16 Cells totalled
Blank Blank BB19:BB41 *

Blank =o12 BB16:BB41 **
Blank <>o12 BB19:BB41 *

=o12 =o12 BB15:BB41 ***
<>o12 <>o12 BB19:BB41 *

=o12 <>o12 BB19:BB41 + BB15 ****
<>o12 =o12 BB16:BB41 **

so as examples,
1) with O12 and K15 both containing year 2005, and K16 blank, I would
expect the formula to total BB19:BB41 and BB15
2) with O12 and K15 and K16 containing 2005, it should total all cells,
i.e. BB15:BB41
3) where O12 & K16 contain 2005 but K15 contains contains 2006,
BB16:BB41 would be totalled, BC15 (for the 2006 column) would be
totalled as in example 1, where O12 and L16 (for 2006 column) are 2006,
then BC19:BC41 and BC15 are totalled.

Regards
Fred

=o12 Blank BB19:BB41 + BB15 ****
<>o12 Blank BB19:BB41 *