Using IF, IFS and AND spreadsheet formulas for Google sheets and Excel.

IF and IFS are great tools to aggregate data as this video shows and AND is another tool that can be used in conjunction with IFS to give more granularity to the data aggregation. I also added a quick chart at the end as a bonus.

Kindly enjoy, like, share, and subscribe.