How to SUM Data Per Week Using Pivot Table

How to SUM Data Per Week Using Pivot Table

If you love low-code solutions then sum data per week using a pivot table is the way to go. The only trick here is to remember, Pivot tables lack the Week grouping. A way around this issue is to group 7 days together. See the below Video for steps to follow: DOWNLOAD...
How to Lookup Items in a List

How to Lookup Items in a List

Looking up items in a list is easy when we use the COUNTIF function. COUNTIF function returns a count of number of times a criterion appears in a dataset. =COUNTIF(dataset, criterion) For example, in the image below, we are counting if the currencies appear in our...