Hi,

Please I need assistance with SUMIFS function to get values between two dates which are on horizontal axis and a third criteria which is on the vertical axis.

As shown in the attached image, I want to retrieve the sum of ‘Weekly EPOS Units’ from the table H2:N14 into column F3:F8 that fall between the dates in columns D and E, and with the Product ID in column C.

I get the #VALUE! working with the data in this format.
Thanks for your help!

​Hi,Please I need assistance with SUMIFS function to get values between two dates which are on horizontal axis and a third criteria which is on the vertical axis.As shown in the attached image, I want to retrieve the sum of ‘Weekly EPOS Units’ from the table H2:N14 into column F3:F8 that fall between the dates in columns D and E, and with the Product ID in column C.I get the #VALUE! working with the data in this format.Thanks for your help!  Read More

​