Sumifs with range of dates

[jevi]

Hi All,

I have this list of data with the date in column B3:B10000 and with the codes from column C2:AN2 and I am using the formula of Sumifs but is not getting the risult. It is maybe the codes are in columns and not in rows?

So i need to sume from a range of date like 01/07/2020 - 13/07/2020 the values that are for the code "0". and so on. But in the formula I have the codes in row:

=sumifs($c$3:$AN3$10000;$B$3:$B$10000;">="&$AM$3;$b$3:$b$10000;"<="&$AM$4;$c$2:$AN$2;$AL5)

0 - and here I wanted to have the sum but my formula above is not working.
1
2
3
4
thank you

	01/07/2020​
	​
​

 

[Fluff]

I'm confused, you say that your data is C3:AN10000, but your criteria cells AM3, AM4 & AL5 are all within that range.

 

[jevi]

Sorry...i just rembered yesterday formula column that was AN

=sumifs($E$6:$AH$10000;$C$6:$C$10000;">="&$AM$3;$C$3:$C$10000;"<="&$AM$4;$E$5:$AH$5;$AL5)

This are the correct ranges. Thank you

 

[Fluff]

Ok, try

=SUMPRODUCT(($C$6:$C$10000>=$AM$3)*($C$3:$C$10000<=$AM$4)*($E$5:$AH$5=$AL5)*($E$6:$AH$10000))

 

[jevi]

It worked super and I used the website that you gave for translating it corretly

Thnx a million....you are really helpful.

 

[Fluff]

You're welcome & thanks for the feedback.