by Crispo Mwangi | May 23, 2023 | BASIC EXCEL
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...
by Crispo Mwangi | May 12, 2023 | INTERMEDIATE EXCEL
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...
Recent Comments