calculate the sum within a specific date

Hi guys,

I think I need some help.

I am working on a little sheet which should sum up all numbers within a specific periode of time.
In my case I want to sum up for example all emails sent within the first month of a year, or the second month and so on.

I tried it with the =sumif function but got no result.

It would be great if it would be dynamic. As I try to make a template for the next years - just by changing the year.

I also added a demo file.

Thank you in advance!

The format of your data does not lend itself to an easy solution. I suggest you change it to a table wirh columns A:D and the data down the rows.

Try

for January

=SUMPRODUCT(($A$4:$F$4="Datum")*($A$4:$F$50>=$K$3)*($A$4:$F$50<=EOMONTH($K$3,0))*($D$4:$I$4=$K$4),($D$4:$I$50))


set k3=01/01/2023

I changed headings to match formula needs (in RED)

with Power Query

Month Name	Geschäftsfälle	Bepreisungen	Anzahl der Emails (Ein- und Ausgang)
January	253	291	1181
February	90	98	433

Please Login or Register  to view this content.

You are welcome

look at this: Power Query

if the problem is solved, hit Add Reputation (bottom left corner next to the post that was helpful)

Glad you were able to get a solution.