A formula in Excel always begins with an equal sign (=), indicating to Excel that the following expression is intended for calculation. For instance, if you want to sum the values in two cells ...

Again, it’s a simple edit to the original function: Select H5. Enter (Table1 [Personnel]=J3) * between the first and second expressions for the second argument (Figure H).