Forum Discussion
Tab formula
how can I have a tab in which I have a drop down tab with two options (a) & (b) that by the choice that is made another tab with a $ value gets calculated to another tab based on which is selected. e...
I suspect nobody really understand your question, probably due to the exessive usage of the word "tab" that makes things quite confusing if I may
#1 To clarify things, could you post a picture that illustrates what you have + a couple of examples of what you expect?
#2 Cf. Welcome to your Excel discussion space!, what version of Excel do you run & on which OS/Platform (Windows, MacOs, Web...)?
I have Excell for Mac and its version 16.88
With data in Table1 (pic. croped):
in J3:
=SUMIF(Table1[RECEIVED FUNDS/COM],[@[COMPANY PAID]],Table1[PROFIT])Table in I2:J4 can be on a different sheet no problem