Hallo! can u please help me on this? it's a kind of an urgent!
I have 2 columns like following:
A B
opt. 100
pess. 50
opt. 150
pess. 80
Total
I want to create a scenario where the total should be based on column A (for example in C1 i write "opt." Then the total should summarize only the cells in column B where in col. A is "opt.". Can u please help me with this? Thanks u very much
I have 2 columns like following:
A B
opt. 100
pess. 50
opt. 150
pess. 80
Total
I want to create a scenario where the total should be based on column A (for example in C1 i write "opt." Then the total should summarize only the cells in column B where in col. A is "opt.". Can u please help me with this? Thanks u very much