E Engineering Accountant Jun 16, 2008 #1 I need to average a set of numbers if they meet a criteria like sumif for averages. Does anybody have a function I could use.
I need to average a set of numbers if they meet a criteria like sumif for averages. Does anybody have a function I could use.
D Dave Peterson Jun 16, 2008 #2 How about using: =sumif()/countif() Engineering said: I need to average a set of numbers if they meet a criteria like sumif for averages. Does anybody have a function I could use. Click to expand...
How about using: =sumif()/countif() Engineering said: I need to average a set of numbers if they meet a criteria like sumif for averages. Does anybody have a function I could use. Click to expand...