=sumif(F3:F15,S4A,E3:E15)/countif(F3:F15,S4A)
This is the formula that I'm putting in and I'm getting the following output:
#DIV/0!
Can you take a look at the image I have attached and see if you can provide any additional assistance?
Also can I use wildcards in this formula for the client names?
Thanks!
|