We can use '=SUMPRODUCT( (MONTH(A1:A10)=MONTH(TODAY()) )* (B1:B10) )' to get a result from dates.

However
'=SUMPRODUCT( (WEEKNUM(A1:A10)=WEEKNUM(TODAY()) )* (B1:B10) )
does not, because WEEKNUM can't handle an array or range.

Please give us a WEEKNUM that handles Array and ranges

Thank you.

Add CTRL+J for Find function to Mac version

As well as you may copy the complete cell selecting the bottom-rigth corner, with this new feature you may be able to copy both; only the format or only the values (your choise on settings) by using the "upper left corner".

Please allow this desperately requested feature, as most Microsoft Excel users need to annotate their spreadsheets with images.

For example, I have a spreadsheet comparing possible travel routes for a trip I am planning. I would like to insert a screenshot of a receipt into a comment/note so I can easily "hide" it or view/"show" it, as needed.

The value of having images within comments/notes is that they will remain linked to the associated box. This would be extremely helpful for spreadsheets containing multiple images.

Why after so many years of people requesting that Find All button be added to the Find dialog box in Mac Excel version it's still not there? How difficult is it just to add a button?

Can there please be the ability to drag the below function down the column and the sheet number changes automatically only. The '$' sign fixes the cell but I need the ability for the sheet number to change automatically in numerical order as I have over 200 rows and 25 columns to change manually!!

='18'!$B$3

Be able to filter information in the chart, similar to what exist on windows.
Example attached(image)

As a student, I have purchased a lifetime license for Microsoft products. It seems ridiculous that I am barred from using functions such as "MAXif". Why can't all functions be made available? I am sure NO company will get rich making extra $ from students in this manner. This is so sad.

In Office 2011 for Mac in the pulldown File menu the user had the option to Clear Recent. This option is missing in Office 2016. It was a useful feature. You should put it back.

I'm making a document for data consisting of time trials. However when Adding the time trials together, it has to be in a certain conditional format. And its inconvenient, repetitive, and time-wasting to put multiple 0s for everything to find averages, and sums of my time trails. ex. 0:04:32

I feel this may be a quick fix. Would appreciate the effort.

Allow Mac users to refresh a Power Query that gets files from a folder (and was created with windows).

What's really galling about excel for mac is that there's no online guidance from MS - I just wasted an hour trying to track down some basic stuff about document inspector and removing metadata before sharing (which, not surprisingly, is 5x as ******* a mac).

SO regretting switching to this product from bulletproof Google sheets.

where is the tab, it's insane!

Please update excel to open files in Catalina OSX, all other 365 programs working.
Excel will open but will not open an excel file

Users should have the ability to embed and image into a cell, so that when you sort data alphabetically, the image moves with its respective column. If google sheets can do this, so can Excel. The "move and size with cells" as well as "move but don't size with cells" options do nothing to help when alphabetizing other data in the same row.

coucou

When I divide 2 cells with results generated by formulas, the division cannot be dynamic!
The calculus fixes on the 1st result found.