Forum Discussion
SUMIF help
Trying to create a total based on 2 pivot tables. What formula do I put in the column in red text. PIVOT #1 ITEM SUM APPLES 5.2 PEARS 3.2 CHERRY 0.4 TOAST 0.2 ORANGE 1....
Your question raises other questions. At this point, when you've had quite a few views but no response, I guess I'll venture into asking one or two of those questions.
- What are the sources for those two Pivot Tables? Are they separate databases, but all in the same workbook?
- Have you considered combining the raw data--those (presumably) separate databases--so that you're doing just a single Pivot Table summary?
- Are you aware of some of the Dynamic Array functions that would enable you, in effect, to virtually combine two sets of data and then summarize from that new virtual array?
- In other words, are you open to different approaches to solving the question?
- Finally, is it possible for you to share the actual workbook (which I presume doesn't really involve types of foods) or a mockup that does illustrate the issue, but includes raw data that is disguised in the form of counts of food types... ?