Is this possible?!

gebobs · #4 02-23-2016, 04:09 PM

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/