Formula Help

Elaine Mullis

Hi all,

I am trying to create a formula that says If "Product delivery location is xxx" provide the average of the "cost per LB" column.

I'd appreciate any help!!

Khasim

Hi @Elaine Mullis

Could you please share an image for better clarity?

What I gathered from your question is.

=IF(XXX = XXX@row, AVG(cost per LB:cost per LB),"")

Elaine Mullis

Hi @Khasim

Screen Shot 2022-09-21 at 7.40.16 AM.png

Please see attached fields!

Khasim

Hello @Elaine Mullis

Did you try this?

=IF(Product delivery Address=Product delivery Address@row, AVG(cost per LB:cost per LB),"")

Elaine Mullis

@Khasim Please see attached it is giving an error

Screen Shot 2022-09-22 at 11.15.20 AM.png

Khasim

@Elaine Mullis

Please use cell@row like mentioned below

=IF(Costoco Mira xxx=Costoco Mira xxx@row, AVG([cost per LB]: [cost per LB]),"")

Elaine Mullis

Screen Shot 2022-09-22 at 1.58.18 PM.png

@Khasim Please see attached - I still received an error for some reason

Khasim

@Elaine Mullis

Your missing square brackets in the formula. Kindly Check the formula. It will help

Elaine Mullis

I did a copy & paste = =IF(YMCO - 217 Read St Portland ME 04103=YMCO - 217 Read St Portland ME 04103 @row, AVG([cost per LB]:[cost per LB]),"")

@Khasim

Khasim

@Elaine Mullis

I need to check what mistake your doing. Is it okay to share the sheet with me?

Andrée Starå

Hi @Elaine Mullis

I hope you're well and safe!

To add to Khasim's excellent advice/answer.

Try something like this. (You can update the LocationA to reference a specific cell instead)

=AVERAGEIF([Product Delivery Address]:[Product Delivery Address], "LocationA", [Cost Per LB]:[Cost Per LB])

Did that work/help?

I hope that helps!

Be safe, and have a fantastic weekend!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up, Awesome, or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!