combining functions

  1. M

    Combining multiple Worksheet change events

    Hello guys and gals, I'm a rookie to VBA and currently trying to combine two separate worksheet changes to my excel sheet. Both work individually, but i haven't found a way to combine them to run. I want them to change certain cells to N/A, dependent on the data in other cells. I know the codes...
  2. S

    SUMIF with MATCH - 2 variables

    Hi all, This is my first post so please excuse any irregularities with the following. I am working on a document with two worksheets. On the first worksheet the data looks as so (not real values): <tbody> Date Invoice Net Category 24/07/2015 JS PLC £3500 11 21/04/2015 MJ LTD £6700 8...
  3. D

    Can I subtract two functions?

    Hey! So, I have a cell in my spreadsheet with the following function: =COUNTIFS($O$7:$AX$7,">="&$A$4,$O$7:$AX$7,"<="&$B$4) It is counting the number of cells in the range O7 through AX 7 that contain dates that fall between the dates in A4 and B4. What I was wondering is if I can subtract...

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top