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

Okay Somali... share your purpose i.e., type the results manually which you want to see and I'll try to get them using formulas.. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

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().