# af2

1. ### Simple =Sum ?

=SUM(H2+K2+N2)-(R2:AF2) Hi I can get this to work. Sometimes the cell in N is blank so it will return #value . Plus I want to - the range (r2 to Af2) Any better way for this to work thanks
2. ### How to calculate a sum if date is behind?

Been scrambling my brain with the formula for this. Appreciate any help. In Cell AF1, I have the formula for today's date =NOW() I have several columns with dates in them. D:D K:K R:R Y:Y In Cell AF2, I would like a formula that calculates how many cells in D:D,K:K, R:R and Y:Y are past due...
3. ### If conditions return no value

My statement is not returning any value unless I manually input values for the statement to evaluate. Font is set to general. I intentionally have my condition values to be equal to a cell. Below is my formulas that should work. I’m stuck and frustrated. I think it’s self explanatory, but...
4. ### Check if column contains text from matrix

Hi, I need help with this, I am stuck. I have this formula: =IF(AF2<>0;IF(AND(ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller spec"&"'!"&"P"&AF2);Indata!P2));ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller spec"&"'!"&"Q"&AF2);Indata!P2));ISNUMBER(SEARCH(INDIRECT("'"&"Bestseller...

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

### 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