Excel 2007 : Function to enter data in 2 columns and get data in 3rd Column automatically

Hi Dilip, The following is my requirement: A function has to be inserted in $C$18 so that ...

If I type ' Office ' in $A$18 and I type ' 2003 ' in $B$18, then $C$18 will automatically dispaly ' 6700 '.

Again, If I type ' Office ' in $A$18 and I type ' 2007 ' in $B$18, then $C$18 will automatically display ' 9000 ' .

The SUMIFS() function suggested by Cutter is working absolutely fine, but we have so far covered the following functions-

IF() , AND(), OR(), NOT(), COUNT(), VLOOKUP(), HLOOKUP(), SUM(), SUMIF(), COUNTBLANK().