=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
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...
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...
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...
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.