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>
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>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
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().
Last edited by somali.cc; 05-21-2012 at 04:55 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks