Hi,
I am looking for a solution for a problem i am having. i need the results for a single month in a sertain year depending on the product discription and status.
Say i am looking for how many connections became active during the month may in 2022, for product type Rock.
I tried it figure it out with Countifs, i got the separate componentens working. but when i try to merge them i get the value error. so i got working the countifs to count de amount of active connections for product rock. and i got the amount of time the date between 1/5/2022 and 31/05/2022 is present in the data. but when i try to combine these fillters i get the value error.
i tried sumproduct but could figure out how to make that work. any ideas?
I am looking for a solution for a problem i am having. i need the results for a single month in a sertain year depending on the product discription and status.
Say i am looking for how many connections became active during the month may in 2022, for product type Rock.
I tried it figure it out with Countifs, i got the separate componentens working. but when i try to merge them i get the value error. so i got working the countifs to count de amount of active connections for product rock. and i got the amount of time the date between 1/5/2022 and 31/05/2022 is present in the data. but when i try to combine these fillters i get the value error.
i tried sumproduct but could figure out how to make that work. any ideas?