SUMIF Excel using criteria from a dropdown list

When we have a large dataset, we can sum specific criteria met data in a lot of different ways. One of them, is SUMIF, a function that returns a criteria-based sum of data.

Find fiscal year in excel

Find fiscal year in excel


In business each transaction is recorded on the date it took place. With this entry the companies are able to determine the annual turnover that took place in their company in the last year. The thing is that companies when referring to years, usually mean financial years or fiscal which do not have to start from 1/1.

Συμπληρώστε τα στοιχεία σας για να εγγραφείτε στο Newsletter μας