How to count number of orders from a list of certain dates

0
votes

I have this sample sheet

https://docs.google.com/spreadsheets/d/1-Zr1ij6KbKbL5IHrVYBNPWmWSWkntZz9amrNBInQY6c/edit?usp=sharing

I need to count the number of orders from both tabs for certain dates: Today, Yesterday, Last 30 days, This month, Last Month, This month last year

result in Tab "Stats"

how to solve this?

1
filtergoogle-sheetsgoogle-sheets-formula

1 Answers

1
votes

0

F4:

=COUNTA(IFERROR(FILTER({V!D4:D;Ventas!D4:D}, {V!A4:A;Ventas!A4:A}=TODAY())))

F5:

=COUNTA(IFERROR(FILTER({V!D4:D;Ventas!D4:D}, {V!A4:A;Ventas!A4:A}=TODAY()-1)))

F6:

=COUNTA(IFERROR(FILTER({V!D4:D;Ventas!D4:D}, {V!A4:A;Ventas!A4:A}<=TODAY(), 
 {V!A4:A;Ventas!A4:A}>=TODAY()-30)))

F7: 

=COUNTA(IFERROR(FILTER({V!D4:D;Ventas!D4:D}, 
 YEAR({V!A4:A;Ventas!A4:A})=YEAR(TODAY()), 
 MONTH({V!A4:A;Ventas!A4:A})=MONTH(TODAY()))))

F8:

=COUNTA(IFERROR(FILTER({V!D4:D;Ventas!D4:D}, 
 YEAR({V!A4:A;Ventas!A4:A})=YEAR(TODAY()), 
 MONTH({V!A4:A;Ventas!A4:A})=MONTH(TODAY())-1)))

F9:

=COUNTA(IFERROR(FILTER({V!D4:D;Ventas!D4:D}, 
 YEAR({V!A4:A;Ventas!A4:A})=YEAR(TODAY())-1, 
 MONTH({V!A4:A;Ventas!A4:A})=MONTH(TODAY()))))