Hello,

I am a novice with Excel and am in need of some help please.

I have 3 columns

A1 | B1 | C1
gMac | 1000 | Ext
dave | 500 | NB
gMac | 500 | NB
gMac | 1000 | EXT
dave | 500 | NB

I would like to get a sum of B1 for 'gMac' if C1 = Ext. This value from the example above would be 2000.

How do I write that in a formula?