Sachin Parmar

COMPANY PROFIT COMPANY PROFIT APPLE 500 APPLE 1000 MICROSOFT 400 MICROSOFT 1000 NOKIA 300 NOKIA 1000 SONY 200 SONY 1000 PIXEL 100 PIXEL 1000 SUM IF 5000 Formula:- =SUMIF(B2:B6,"<1500",E2:E6)

NAME POST ARUSH CLERK AXAY PEON AJAY PRINCIPAL RAVI TEACHER KARAN OTHER NIRAV CLERK HARSHIT TEACHER SULAY TEACHER ANAND PEON MIHIR PRINCIPAL COUNT IF 3 Formula:- =COUNTIF(B2:B11,"TEACHER")

M1 10 M1 50 M2 20 M2 40 M3 30 M3 30 M4 40 M4 20 M5 50 M5 10 TOTAL 300 TOTAL Formula:- =SUM(C3:C7,F3:F7)

A B C D E F G H I 1 ORDER 10247 10249 10250 10251 20252 10253 $16.00 2 ID $14.00 $18.00 $7.00 $16.00 $16.80 $64.00 6 3 QUANTITY 12 9 10 6 20 40 $14.00 FORMULAS: PASTE THIS FORMULA IN D1 CELL. =HLOOKUP(10251,A1:G3,2,FALSE) PASTE THIS FORMULA IN D2 CELL =HLOOKUP(10251,A1:G3,3,FALSE) PASTE THIS FORMULA IN D3 CELL =HLOOKUP(10247,A1:G3,2,TRUE)

A B C D E F G H I J 1 NO NAME PRIZE NO NAME PRIZE 2 1 BOLT 100000 4 LEWIS 15000 3 2 REGIS 3 BLAKE 50000 3 3 BLAKE 1 BOLT 100000 4 4 LEWIS 2 REGIS 20000 5 5 POWELL 5 POWELL 25000 FORMULAS: PASTE THIS FORMULA IN D2 CELL. =VLOOKUP(B2,H:J,3,FALSE)