View Single Post
 
Old 02-23-2016, 03:57 PM
sammielou sammielou is offline Windows 7 64bit Office 2013
Novice
 
Join Date: Feb 2016
Posts: 9
sammielou is on a distinguished road
Default

=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!
Reply With Quote