ExcelBanter - How do I add items within the last year

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I add items within the last year (https://www.excelbanter.com/excel-discussion-misc-queries/62955-how-do-i-add-items-within-last-year.html)

Kevbro7189

How do I add items within the last year

Dave Peterson

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

All times are GMT +1. The time now is 10:15 PM.