Forum Discussion
Some sort of a sumif formula
Hi,
Thank you for your answer, however, it doesnt work,
The already existing formula on my excel sheet is the following : =IF($C252="BE";$M252;0)
C252 is one of the conditions of the formula, but it's specific text, "BE", and i'd like to be "not blank" and to be detected in a range of cells, for example, A252 to D252, is it possible ?
Best regards,
Hi, thank you for the clarification.
Try using this instead:
=IF(NOT(OR(ISBLANK(A252:D252))),$M252,0)
This returns the value in M252 when range A252:D252 is entirely not blank. That is, when all cells within that range are not empty. If you wanted to return the value M252 whenever at least one cell in that range is not blank (but others may be), then replace OR() with AND().
Hope this helps.
Martin
- Hi,
I tried the formula but m252 is not recognided as a cell, do you have any idea why and how to make it work ?
Best,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 ?
