Forum Discussion
Please help on formula to find total of two criteria?
Hi
I am trying to get the total of date selected to match dietary, can anyone advise what is the formula to use? file as attached. Thank you
Another alternative could be Power Query. In the attached file you can add data to the blue dynamic table. Then you can click in any cell of the green table and right-click with the mouse and select refresh to update the green result table.
The attached version contains three different solutions:
- COUNTIFS formula
- PIVOTBY formula (Microsoft 365 only)
- A pivot table
