Sum by financial year

[brubru24]

Good morning/evening,

I have a file that shows products in a column. Next to the same individual product column, I have three criteria: unit cost, volume and cost for the period. Then next do it I have the sums of year 1-2-3 and so on and next to that I have the columns showing he monthly numbers for each criteria mentioned above.

In a second sheet, I would like some help with a formula that returns the financial year sum of the cost per period criteria. Below is a screen shot


http://tinypic.com/r/2djaz2g/9

http://tinypic.com/r/otn4ok/9





Thank you in advance for you help

Bruno

 

[Rijnsent]

Hi Bruno,

try the sumifs formula, e.g.:
=SUMIFS(B7:S7,B3:S3,">="&DATE(2018,1,1),B3:S3,"<"&DATE(2019,1,1))

Cheers,

Koen