Quote:
Originally Posted by sammielou
=sumif(F3:F15,S4A,E3:E15)/countif(F3:F15,S4A)
|
You would need to put the client name in quotes since it is text.
Alternatively, you could have a list of clients in a table and the formulas the next column over with the formula referencing the address of the client field.
Quote:
|
Also can I use wildcards in this formula for the client names?
|
http://www.bluepecantraining.com/por...ifs-functions/