View File Home Insert Draw Page Layout Formulas Data Review Help Editing v Calibri 11 B I Av ... Ev ab Merge v General $ v Conditional Formatting R33 " X VA K L M N O P A B C D E F G H J Name Department State Hours Rate Finance 59.60 39.97 Find total hours for the below criteria: Abrams 58.60 23.74 Dean 22.30 Buckleitner Sales CT Cohen Executive NJ 40.00 17.88 Dean Executive 738.9 Dean Executive CA Colvin Executive VT 29.30 13.09 LD CO CA 52.90 17.90 Dean IT >20 Coules Sales 10 Dean IT VT 87.60 23.00 11 |Dean Finance NY 33.20 24.05 12 Dean HR NJ 87.30 19.68 Find how many Executives were from VT or NJ 13 Dean Finance PA 96.30 35.92 Executive CA Executive NJ Dear Finance 85.30 24.14 15 Dear HR CA 11.90 32.14 Executive VT 16 Dean Executive VT 15.10 45.09 17 Kreanow Sales VT 32.40 14.37 18 Leung Sales CA 78.40 44.98 19 Liebowitz HR PA 16.20 33.04 20 Lowenfeld Graphics CT 80.40 16.53 21 Marciano IT NY 70.60 20.84 22 Marone Marketing CT 22.50 11.51 23 McGowan Graphics NJ 84.60 29.76 24 Cohen Sales CT 10.20 23.74 25 Minzner Sales NY 39.90 41.66 26 Novick Marketing CA 59.10 34.83 27 Cohen Marketing NY 80.10 44.62 28 Cohen Graphics NJ 13.20 12.06 29 Philips Sales NJ 95.00 48.63 30 Rampulla Graphics NJ 78.50 28.73 31 Dean Executive PA 32.40 24.54 32 Dean Executive CA 23.20 45.11 Sipes IT CA 46.40 38.80 30.30 34 Stryker Marketing VT 97.20 35 Wilson Marketing NY 13.60 20.14 36 Cohen Executive PA 26.60 15.99 37 38 Total hours for NJ 39 Total hours for PA 40 41 Average rate for VT 42 Average rate for CA