Here is my problem: I want to write a formula in cell P11 that includes
information from columns B,E,F, and G. In column B, I have two types of data
(ZN and ES). If the value of B3=ES, then i want to multiply the value of E3
x G3. If B3 = ZN, i want to multiply F3 x G3. Then i want to add the sum of
the ZN cells with the sum of the ES cells so that this total is in P11.

B E F G
3 ES 6 5 2
4 ZN 6 5 1
5 ES 6 5 4
6 ZN 6 5 3

B3=ES, thus E3 x G3 or 6x2=12
B4=ZN, thus F4 x G4 or 5x1=5
B5=ES, thus E5 x G5 or 6x4=24
B6=ZN, thus F6 x G6 or 5x3=15

Then in cell P11 i want the sum of 12+5+24+15.

how can i do this?

Many thanks!

EG