Jan 04 2023 07:34 PM
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. example if I selected (a) and the profit is $100 and I select two more (a) with each being $35 the tab will say $170
Jan 05 2023 04:18 AM
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...)?
Jan 05 2023 04:51 AM
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
Jan 05 2023 05:29 AM
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