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...
Hi, to all!
In Matt Mickle's file, you can use too (in E2):
=SUMIF(A$2:A$15,D2&"*",B$2:B$15)
And drag it down. Blessings!
In Matt Mickle's file, you can use too (in E2):
=SUMIF(A$2:A$15,D2&"*",B$2:B$15)
And drag it down. Blessings!
Hi
Thank you for your answer but I am such a beginner and dont get it. What am i doing wrong?
- Problem solved, thanks :)
Selena - Glad you were able to get the solution.
John Jairo Vergara Dominguez - nice use of Sumif() with the wild card!
