Questions – Greatassignmenthelp.com

what value would be returned based on the formula in cell d49

Question:- what value would be returned based on the formula in cell d49

What value would be returned based on the
formula in Cell D49?

D

E

F

42

 Conference Room Location Staff ID

43

 D East 19106

44

 C North 19122

45

 A South 19107

46

 E South 19104

47

 B South 19147

48

49

 =COUNTIFS(E42:E47,”South”,F42:F47,”19104″)

Posted

in

by

Jay Cooper

Tags:

Comments

Leave a Reply

Your email address will not be published. Required fields are marked *