Geomean based on IF condition not working

Malick

New Member
Joined
Jul 10, 2014
Messages
18
Hi,

I am trying to use the Geomean formula with an if condition but it is not working. I need to calculate geomean of values where my if condition is TRUE. Can you please help me fix the code. The current code is fetching GEOMEAN for the entire column of my table, ignoring the IF condition. I only need geomean of 'Final Score' values where my city is matched. Thanks.
Code:
=IF(Table1[@[city]]=[@City], GEOMEAN(TableaCalculation[Final Score]),0)
 
Last edited:
It works this time sir. I don't know what I was doing wrong previously but I copy pasted your formula without the curly braces and entered it as an array and it works. Sorry for the confusion and thanks a million for solving this issue :) Merci bien
 
Upvote 0

Excel Facts

What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.

Forum statistics

Threads
1,213,538
Messages
6,114,220
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top