Tab formula

[onpointsupplies]

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 

[#2]

any ideas would really help ??? @onpointsupplies 

[#3]

Hi @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...)?

[#4]

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 

 

@Lorenzo 

[#5]

I have Excell for Mac and its version 16.88

[#6]

@onpointsupplies 

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

[#7]

@onpointsupplies You're welcome...