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...
any ideas would really help ??? onpointsupplies
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
I made an small portion of what the book would actually look like but hopefully this can help clarify what I'm trying to accomplish and some one can help me with it now. thank you