View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default 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