Dont Apply formula if

[ExcelFish2020]

Hi

I want to apply the sumif based on the date and the Model Name which is workin, How ever if the date and the model are the same as the the line above i do not want the formula applied so Cell d6 will recognize that the date model are the same as above so a £0.00 repair amount will appear instead of £250 in cell D6.
Your help with this matter is really appreciated.

[etaf]

try
=IF(AND(A5=A4,B5=B4),0,SUMIFS('Repair sheet'!E:E,'Repair sheet'!A:A,A5,'Repair sheet'!B:B,B5))

[ExcelFish2020]

Thanks for your help with this, Really Appreciated.

[alansidman]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.

Also, as a relatively new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.