advanced sumifs with many criterias for each criteriaarea
Posted on 2012-09-18
I have a problem creating an advanced sumifs formula, that I hope you can help me with:
I have to select a number of accounts which should be my first criteria, from a number of projects, and sum the amounts that fullfills the combination of one of the accountnumbers and one of my projects.
Can that be done? I supposed that it can be done by putting in an OR statement as my criteria in both criterias, but it does not work for me.