Combining two Functions
=COUNTIF(B2:B15,"Cooking Dinner") Returns all count Cooking Dinners =SUMPRODUCT(1*(YEAR(A2:A15)=2023)) Returns all count of year 2023 I would like to count how many times “Cooking Dinners” is in the year 2023. Or count all “Cooking” in the year 2024 no matter of if it is lunch or dinner.Spreadsheets in Space just became more powerful with a new API in Microsoft Excel
We are always looking for new ways to help people do more and create new experiences, so the Excel team was excited to collaborate with CCP Games as they developed a powerful new Excel add-in that will supercharge the EVE Online game experience by making data analytics accessible to all players, no programming knowledge required. This valuable tool enables players of all skill levels to effortlessly access and analyze data to optimize gameplay as they strive for galactic domination.Access Takes a Trip: News From Around the Globe
Check out our most recent blog post that provides a brief overview of some of the team's most recent user group sessions. We would like to have more of these in many more locations moving forward (both domestic and international), so if you have suggestions, please let me know! https://techcommunity.microsoft.com/t5/Access-Blog/Access-Takes-a-Trip-News-From-Around-the-Globe/ba-p/1015527
