

September 13, 2020

Can someone help me with formulas with questions in Excel file attached here please?
(PS Excel formula, not Python please)
Thanks in advance!


Trusted Members
Moderators

January 31, 2022


VIP

Trusted Members

December 7, 2016



September 13, 2020

@Riny van Eekelen
Yes, "how many" should be, sorry for the confusion. Looking for SUM of numbers.
For instance, Irene sold 19 notebooks, and that is one number I'm looking for with a formula.
Excel 365.
@Riny van Eekelen, yes I know it could be done with Pivot, I have that already, but for this case, I'm trying to solve this with a formula.


Trusted Members
Moderators

January 31, 2022

Although Anders mentioned that this could be done with a pivot table, his file included a formula solution with SUMIF.
Attached file does include a power pivot (table) solution. Since you have two separate tables joined by the Model reference, you can relate the two in a small data model and create a pivot table from there.
Edit: I now see that you want a formula solution anyway. Will Anders' SUMIF work for you?


Trusted Members
Moderators

November 1, 2018

1 Guest(s)
