Forum Discussion
Excel
Hi! I need a fast answer. How can I sum different dates(which have different years) and their values? For example i have dates from 2008-2017 and in next row i have the number of counted birds, I ne...
This is a great opportunity to use the SUMPRODUCT() function. I have created an example file for your reference. Please see attached:
Here's some additional information on the function: https://support.office.com/en-us/article/sumproduct-function-16753e75-9f68-4874-94ac-4d2145a2fd2e