EddyTheEagle
New Member
- Joined
- May 28, 2019
- Messages
- 2
Hi
I need to sum up the sales in the range R56:R5044
I have a daily date range N56:N5044
and 2 date criteria in Q5 & Q6 which are using the following dates:
01-02-2019
01-03-2019.
I have a Sumif which is working (=SUMIFS(R$56:R$5044,$N$56:$N$5044,">="&$Q5,$N$56:$N$5044,"<"&$Q6))
However I want to be able to filter on various criteria between A56:A5044 and after filtering see the sum of the sales (like a subtotal).
Can anyone who is good with formulas help (If you need more clarification please let me know)
Thanks in advance
Eddy
I need to sum up the sales in the range R56:R5044
I have a daily date range N56:N5044
and 2 date criteria in Q5 & Q6 which are using the following dates:
01-02-2019
01-03-2019.
I have a Sumif which is working (=SUMIFS(R$56:R$5044,$N$56:$N$5044,">="&$Q5,$N$56:$N$5044,"<"&$Q6))
However I want to be able to filter on various criteria between A56:A5044 and after filtering see the sum of the sales (like a subtotal).
Can anyone who is good with formulas help (If you need more clarification please let me know)
Thanks in advance
Eddy