Sumif using a variable

CamCrichton

Hi,

I have a simple sumif adding values from column Estimate based on some text being present in column Artist. The result is all the time allocated to a particular artist.

=SUMIF(Artist:Artist, "Alex", Estimate:Estimate)

In order to make this more compact I would like to have a pull down menu with all the artists names. The name selected from the drop down should then replace "Alex" in the formula.



Can anyone shed some light on how to set this up?



regards,

Cam

Andrée Starå

Hi Cam,

Try this.

[Artist Selector]1 - (change this to whichever cell you put the artist selector in.

The SUMIF will sum everything in the column Estimate where the Artist Sector is the same as the artist.

=SUMIF(Artist:Artist; [Artist Selector]1; Estimate:Estimate)    

The same version but with the below changes for your and others convenience.  

=SUMIF(Artist:Artist, [Artist Selector]1, Estimate:Estimate)

Depending on your country you’ll need to exchange the comma to a period and the semi-colon to a comma.

Did it work?

Have a fantastic week!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

CamCrichton

Thanks Andrée,

commas and colons in Australia



=SUMIF(Artist:Artist, ArtistSelect2, Estimate:Estimate)

cheers,

Cam

Andrée Starå

Happy to help!

Best,

Andrée