offset variables fail

  1. gardnertoo

    OFFSET formula working within a COUNTIF but not within a SUMPRODUCT

    On a spreadhseet running in Excel 2007, I have the following formula in cell D7, where it works just fine: =COUNTIF(OFFSET($S$2112:$S$2211,,(ROW()-ROW($D$6))*4),"OPEN") It looks at a column of OPEN and CLOSE texts and counts the number of OPEN, straightforward enough. So I took the OFFSET...
  2. KG Old Wolf

    Error 13 - Type Mismatch

    The code below works but I want to substitute the variables in red for the literals in blue. I can see the correct numeric values being obtained by the red variables. Yet, as soon as I substitute the red variables, I get an error 13 - type mismatch. The values in red are always numerics and are...

Watch MrExcel Video

This Week's Hot Topics

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
Top