I want to count certain values using an excel formula. I am using CountIFs but the problem is that my value has the current year as a part of the string. For example one of the values are CMS 2015. I was wondering if there was a way to incorporate a function in the criteria string so that it will automatically calculate the year? Also, I would like to search for the same string only one year ahead of the current (eg. CMS 2016). Any help would be greatly appreciated!
mardi 24 février 2015
Automatically calculate current year in criteria string of CountIFs statement
Inscription à :
Publier les commentaires (Atom)
Aucun commentaire:
Enregistrer un commentaire