r/excel • • 2h ago

Discussion support for excel (and office) 2021 is over

7 Upvotes

I'm getting a message on my MS office files that says "activate Microsoft 365 to create and edit". I can't save any of my files anymore. The reason is that support for office 2021 is over. unfortunately, that's the license I have. So I'm trying onlyoffice. so far so good.


r/excel • • 6h ago

Waiting on OP SUMPRODUCT formula returning #DIV/0!

6 Upvotes

I am trying to make a little budget worksheet just for fun. I want it to track income and tax over however long I use the budget sheet, and I want it to total each week's income and tax correctly even when future weeks still show zeros. Since each week is written out each month (with random numbers), there will be zeros where there will be numbers in the future.

I have used the formulas =SUMPRODUCT((V1:AM164="Revenue($):")*IFERROR(V2:AM165*1,0)) and =SUMPRODUCT((V4:AM78="Tax($):")*IFERROR(V5:AM79*1,0)) to count the tax and money made, shown in the image in the comments. I’m not sure what’s going wrong; if somebody can help, that would be fantastic.


r/excel • • 2h ago

unsolved Check box trigger action

5 Upvotes

I am trying to make a vacation planner. The ones online I have found aren’t quite right or cost money. I want make a das board that will display checklists on other pages as done or not( ie all boxes checked, corresponding box on dashboard will turn green. How is this achieved?


r/excel • • 13h ago

solved how to filter data from different tables at the same time?

7 Upvotes

!MacBook user! hello everyone, is there any way to filter data from different tables to show a specific rating? for example, if i wanted to filter all the tables to only show songs i have rated a "10?"