Can you be more specific about what you want to do? It would help if you showed what result you want from that data.
When you say you want to use two criteria, what range do you want to apply those criteria two? By "multiple" do you mean sum all values that meet either criterion?
There are no formulas in this file. What is the SUMIFS formula you are trying to use?
SUMIFS by definition can specify multiple criteria but SUMIFS sums all values that meet all criteria. If you want values that meet any criterion, the simplest way to do it is to use multiple SUMIF or SUMIFS formulas. For example, if you have a list of numbers in A and you want to sum all the numbers with with Apple or Orange in column B, would do this:
if you do this:
the result will be 0 because no cell can be both Apple and Orange.
Also it would be better to give the actual pivot table instead of a suggestion of what it looks like.
Bookmarks