totals

[Joanna_gr]

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

 

[Derek]

Aladin
Wow, I have to hand it to you, that is very neat and spot on.
regards
Derek

 

[Derek]

Aladin
You were also clever enough to spot that my mental faculties had completely let me down in my first post too. (I found later that my array formula didn't even work properly either). Might be the beer, or just a bad day, better slink off to bed before I cause any more grief.
Best wishes
Derek

 

[Joanna_gr]

I did it at last! thank you all very very much!!!!!