Formula error Unparseable

Jacks

I've tried over and over again to correct this unparseable error without success. I've scanned the forum also. This is a pretty basic question I am unable to solve.

Basically what I am trying to do is if the status ="Active New" then total the sum for the column 1st QTR 2024

In this forumla the 2 in bold are sheet reference names

=SUMIF({Active New}, "ACTIVE New"),=SUM({Active 1st QTR 2024}))

I did try them one at a time and they work, so it must be some type of syntex error.

If I perform this in the sheet summary on my source sheet, it works.

=SUMIF([Contract Status]:[Contract Status], "ACTIVE New", [1ST QTR 2024]:[1ST QTR 2024])

I need it to work in my rollup sheet where I reference the sheet and the columns

rrenee

Hi, I think this may work for you:

=SUMIF( {Active New}, "ACTIVE New", {Active 1st QTR 2024} )

=SUMIF( criterion_range , criterion , range_to_sum )

The format is switched around, but you can also do one criterion in SUMIFS if desired:

=SUMIFS({Active 1st QTR 2024}, {Active New}, "ACTIVE New")

=SUMIFS( range_to_sum , criterion_range_1 , criterion_1, … )