Formula Issues

Beth Faircloth

Hey all,

Wondering if you could help with an issue. I need to get an average (days) for a column, but referencing another column. For example, I have 2 options (Existing and New) in a drop down list in one column and in another column I have total days. I'm trying to get an average of days for each of the options. 

 

 

Brian Campbell

I would do =sumif()/countif() with the criteria being if "Existing Store" is in the range then do the same for "New Construction"  

Beth Faircloth

It came back as an "Unparseable" error. Thanks for trying

Brian Campbell

is this what your formula looked like?

 

=SUMIF([Location Type]:[Location Type], "New Construction", [Sample Request to Receipt]:[Sample Request to Receipt]) / COUNTIF([Location Type]:[Location Type], "New Construction")

Beth Faircloth

It was. Looks like I transposed the i and e in receipt. lol Totally missed that. Thanks a bunch. 

Brian Campbell

No problem, happy to help

Paul Newcome

They have actually rolled out a few months ago an AVERAGEIF function that sounds like it would be a perfect fit (and much shorter).