Excel Examples

Example Workbook

Data Tables

Data Table in Excel - Examples, Types, How to Create/Use?

Sumifs with multiple conditions

=SUM(SUMIFS(data!$A:$A,data!$T:$T,{"C","N","B"}))

Quarter of Year

=ROUNDUP(MONTH(B2)/3,0)

Created: 2022-07-13-Wed
Updated: 2023-11-21-Tue