Cell Formula or Cell Input

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Try this:
If the input cell is A1 . . .
=SUMIF(B13:B28,IF(ISBLANK(A1),10,A1),P13:P28)

Does that help?

***********
Regards,
Ron
 
Ron
I may be doing something incorrect...it didn't work. I may not have clearly
defined my problem. Is it possible to have a formula in a cell and also be
able to make a manual entry in the same cell without losing the formula?
 
Not with out-of-box functionality.
You could write a vba program to alter Excel's behavior for that cell if yuo
really needed to.

***********
Regards,
Ron
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Multiply Cell Values which include text units 6
=AND($B$12<>"",$B$12<TODAY()+60) What does the <> mean in this? 3
Repeat Cell Based on the Value-Excel 2003 3
Formula assitance needed 2
resettable, over-ridable, default cell values 0
help with formula for last input in column 6
IF Formula Porblems 1
How to keep formula and be able to input value in cell? 0

Back
Top