Sumifs

[Steve84]

Hi,

Any help greatly appreciated as I cannot get my head around this formula.

Basically I am looking to create a sumif where the months below are within a drop down menu and when this changes month the data will update to marry the month selected? I have a separate sheet saved with all the data in so just need to point the sumifs to those data labels but cant seem to make it work

[TABLE="width: 289"]
<colgroup><col><col><col><col></colgroup><tbody>[TR]
[TD] [/TD]
[TD] [/TD]
[TD="colspan: 2"][/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD]July[/TD]
[TD]August[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Score[/TD]
[TD]9.2[/TD]
[TD]9.1[/TD]
[/TR]
[TR]
[TD="colspan: 2"]No. of reviews[/TD]
[TD]17[/TD]
[TD]83[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Open Rate[/TD]
[TD]31%[/TD]
[TD]37%[/TD]
[/TR]
[TR]
[TD="colspan: 2"]Click Rate[/TD]
[TD]4%[/TD]
[TD]11%[/TD]
[/TR]
</tbody>[/TABLE]

 

[steve the fish]

Hi. It depends what your data looks like as to how you would do this. Is 'July' a date formatted to look like 'July' or is it just text. What is in your data? Dates or text representing a month?