D
Dave Peterson
=sumproduct(--(year(a1:a10)=2005),b1:b10)
Adjust your range to match, but don't use the whole column.
=sumproduct() likes to work with numbers.
The -- converts trues and falses to 1's and 0's.
Kevbro7189 wrote:
Adjust your range to match, but don't use the whole column.
=sumproduct() likes to work with numbers.
The -- converts trues and falses to 1's and 0's.
Kevbro7189 wrote: