SOLVED

Excel Formulas

Copper Contributor

Hi,

 

My excel is not giving me the fields necessary for each formula i am trying to use. Example: if i select +Sumif it does not tell what i need to select to complete the formula, namely, the range, criteria and sum_range hence i don't know what data i need to select for each formula.

 

Can you help me please?

It is driving me crazy!

Thanks!

Duarte

4 Replies
best response confirmed by dbruges (Copper Contributor)
Solution

There is a setting for this, I don't have 365 so this might be in a different spot for you but for me it's under, File, Options, Advanced, Display - Show Function Screen Tips, maybe this got turned off accidentally?

Thanks a lot! it's exactly it!

Thank you,

Duarte

Yes, that's exactly it! thank you very much!
Duarte

Your welcome. 

1 best response

Accepted Solutions
best response confirmed by dbruges (Copper Contributor)
Solution

There is a setting for this, I don't have 365 so this might be in a different spot for you but for me it's under, File, Options, Advanced, Display - Show Function Screen Tips, maybe this got turned off accidentally?

View solution in original post