Sum IF Excel Function

[filip.irena]

Hello

could sb help me with the following problem.

I need a formula which can do the following:


1) Calculate the sum of orange and blue tvs- Numbers and turnover
2) Every month should be an automatic update of the fomula with for example the today and month function so the right column is always searched for the sum (If at the current month-November- a raw "d" was searched for , next month for December I would to look for the collumn "E" automaticaly without chaning manully the formula)
2) Turnover: How to write a sum formula for turnover, which takes account for different prices per year of the same product (2019 and 2020 for each month there is a different price but the item name is the same)

[Pete_UK]

You should attach a sample workbook - the yellow banner at the top of the screen tells you how to.

Hope this helps.

Pete

[filip.irena]

With the attached File.

[FDibbins]

Is this a homework assignment?

[filip.irena]

I finished unfortunately with my last homeworks assignments 10 years ago. It is just an example because I don't want to provide my real data. The formula is imporant.

[Glenn Kennedy]

have you any flexibility concerning the layout of the tables in SUM. The use of those ghastly merged cells in the rows with Blue and Orange will cause ENORMOUS complications.

Also, i cannot understand why B17 is labelled October and B 9 is labelled 2019 11 which (to me) implies November!!