Below is a link to the data I am working with: http://ift.tt/22Ws6PF
I am trying to make a single function which will sum the accomplishment points of a single day with a range of different acronyms. This means I need a function that looks something like this:
SUMIFS(Accomplishment points, range-of-acronyms,OR( Acronym="SNE",Acronym="SCE", Acronym = " ", Acryonym = "TSD"), range-of-being, Begin-date=desired-date, range-of-end-date, enddate=desired date)
I know you can't us OR, but SUMIFS(SUMIFS()) doesn't work in this case either. I also have tried using ideas like SUMIFS(INDEX(METHOD) but that didnt seem to work either.
I appreciate your help in advance. I have looked around for people doing similar things but have been unable to find a solution that works with how many OR statements I need.
Aucun commentaire:
Enregistrer un commentaire