How do I add items within the last year
=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:
--
Dave Peterson
|