Forum Discussion
bbsin
Mar 10, 2025Iron Contributor
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
HansVogelaar
Mar 10, 2025MVP
The attached version contains three different solutions:
- COUNTIFS formula
- PIVOTBY formula (Microsoft 365 only)
- A pivot table