Is this possible?!

sammielou · #1 02-23-2016, 03:57 PM

=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!

gebobs · #2 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/