Forum Discussion
Some sort of a sumif formula
Hello, I have an issue with a formula i can't figure out how to make it work, My goal is to apply a summ in a cell (A1 equals A2 for example) but ONLY if 2 specific cells have any data inside...
Hi, can you please check which decimal separator do you use in Excel? If you treat decimals with a "," (comma) then you will need to use this:
=IF(NOT(OR(ISBLANK(A252:D252)));$M252;0)
Hi,
Thank you for your reply, it works now.
i need the cell to show "0" when conditions are not met, is it possible ? what would i need to add for it to work ?
Thank you for your reply, it works now.
i need the cell to show "0" when conditions are not met, is it possible ? what would i need to add for it to work ?
- At the moment, when i apply the formula and remove the text in the range of cells (a252:d252), the result of the formula stays and it shows a "formula error" icon on the cell,
Could you help me with that ?
Best,You can safely ignore this, but if you want to remove the error triangle:
- Select File > Options.
- Select Formulas in the navigation pane.
- Scroll down to the section Error checking rules.
- Clear the check box Formulas referring to empty cells.
- Click OK.
