Forum Discussion

Biggy_E's avatar
Biggy_E
Copper Contributor
Apr 04, 2024

Excel formula Assistance--Help

Hi! Excel Community!, Looking for your assistance in how to create a formula that does the following: IF  cell = 2023 or 2024, then Sumifs (based on the criteria i selected), otherwise, Sumifs (b...
Formulas and Functions
rachel's avatar
rachel
Iron Contributor
Apr 04, 2024

Biggy_E 

 

I believe there are syntax errors in your formula.

In cell C15 in "Report1" tab, you can use below:

=IF(
    C$14 = "2024",
    SUMIFS(
        datatable_24[Revenue],
        datatable_24[Division], Report1!$B15
    ),
    SUMIFS(
        datatable_23[Revenue],
        datatable_23[Division], Report1!$B15
    )
)

 

Or better, you can use INDIRECT to convert a table name to a range.

Like what I have done in sheet2 in the attached sample:

 

Resources