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

Posted: 28-06-2024

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″)