Calculating figures based on dropdown selection help

[sjohnson77]

Hi Everyone,

I am having real problems calculating values based on certain drop down selections I make.

For example, for my business I am trying to calculate the spend per year by selecting a drop down and choosing the year I want to be calculated. I already have the spend data for all the financial periods within a year, but I need the spreadsheet to recognize the selection on my dropdown menu and to automatically calculate the values for me.

I have attached a screenshot with some fake data to help as a visualization.

Any help would be greatly appreciated!

Kind regards

 

[etaf]

using XL2BB (see menu or my signature for details )or put the file on a recognised what i would call trusted share , like dropbox, onedrive , mega, google sheets

Is the year TEXT ?
SUMIF() should work -
SUMIF($C$2:$C$1000, H2, $E$2:$E$1000)

But if you have dates in the cell , then you may need to convert to use YEAR()
But whats in cell C - a date or TEXT, and what date - so are these all different dates and formatted to just show year
Whats in cell H - - a date or TEXT so is 2017 - actual always 1st Jan 2017 and formatted to just show year

 

[sjohnson77]

Thank you for your help etaf! You guessed correctly, the years were text only so your formula worked perfectly

Appreciate the fantastic help and quick response

 

[etaf]

you are welcome