I currently have a cell that has the folowing formula
=SUMIF(B13:B28,10,P13:P28)

Is there a way for this cell to allow a manually input value and if none
then utilize the above formula for an automatic cell value?

What would the formula be?