# 3-d

1. ### Attempting SUMIF across worksheets using INDIRECT and SUMPRODUCT

Hi, I'm trying to SUM cell J4 across a range of worksheets but only SUM if a static date, K4, on the worksheets are equals too or less than today's date. This is my current attempt at getting this formula to work...
2. ### 3D equation

Hello all, I am tracking hours over the year with the weekly hours total placed in cell M3. In cell N3 I have this equation =AVERAGE('WEEK 1:MASTER'!M3) which is keeping a year to date average of hours. which is working great, except if I add a new person to the sheet to track the hours, the...
3. ### Latest Day (MAX across Multiple Sheets)

I need to be able to find the most recent date value across multiple sheets based on a given input to look up. I've seen a few methods to do this, but I haven't had any luck adapting them to my project, which requires a LOT of flexibility in where this value might be. Here's what I've got so...
4. ### Plot with X,Y, and Z axes

Essentially I'm trying to make a 3-d plot similar to this: http://soft.proindependent.com/doc/manual-en/pics/3d-gallery-mesh.png I have 3 columns of data, one column for each axis. I've been looking through some older posts and they have said there's no straightforward way to do this in excel...
5. ### Insert cells in 3-D ranges

I have a workbook for tracking my billing. In the Totals sheet, I have 3-D ranges to total all the billing per day across each sheet (client). When I insert rows to a particular client's sheet for a given day (to accommodate multiple billing items), the 3-D range does not update to include...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back