Sum against matching criteria onto another sheet

StefSoks711_PP

Hi!

I'm trying to create my calculation sheet in order to develop my dashboard, but I can't get my SUMIF to work. This is a project tracker in that I was able to get my project-type counts to work with the COUNTIF formula, and now I want to do the same but on the total $ amount column, however I cannot get this to work!

The syntax i'm using is: =SUMIF({APM Request Form - - SOW Total}, [Primary Column]@row)

DKazatsky2

Hi @StefSoks711_PP,

The syntax for your SUMIF is off, it should be SUMIF(range, criterion, [sum_range]).

Give something like this a try.

=SUMIF({project-type}, [Project-Type]@row, {APM Request Form - - SOW Total})

Make sure to change range names and column names as appropriate to your setup.

Hope this helps,

Dave

StefSoks711_PP

Hi Dave,

Thanks for the help, but it's still not working. Here's the background, I have a project tracker where the agency name is captured for each project requested (for privacy, i had to black out the names in the Agency/Vendor column).

I'm then summarizing the data into a new worksheet where I want to show the total amount per agency below. I was able to successfully get "COUNTIF" to work to see total project/contract counts, but I'm struggling with calculating the total $ field. Note that the Agency/Vendor list is under the "primary column" in the new sheet.

jmyzk_cloudsmart_jp

Hi @StefSoks711_PP

As @DKazatsky2 pointed out, you need to use the syntax SUMIF(range, criterion, [sum_range]).

Therefore, in your case, you need to insert the criterion range, as shown in bold below. (the Agency/Vendor column)

 =SUMIF({APM Request Form - - SOW Total}, {APM Request Form - Agency/Vendor}, [Primary Column]@row)

DKazatsky2

Hi @StefSoks711_PP,

This is what you need.

=SUMIF({APM Request Form - Agency/Vendor}, [Primary Column]@row, {APM Request Form - - SOW Total}

Make sure to create the reference "{APM Request Form - Agency/Vendor}" pointing to the "Agency/Vendor" column the same way you made the "APM Request Form - - SOW Total} reference.

jmyzk_cloudsmart_jp

@StefSoks711_PP

@DKazatsky2 is right.

Mine should have been the SUMIFS function.

=SUMIFS({APM Request Form - - SOW Total}, {APM Request Form - Agency/Vendor}, [Primary Column]@row)

Or as Dkazatsky2 correctly commented;

=SUMIF({APM Request Form - Agency/Vendor}, [Primary Column]@row, {APM Request Form - SOW Total})

https://app.smartsheet.com/b/publish?EQBCT=963b5afc41c34b65b4c3c35064310bf9

https://app.smartsheet.com/b/publish?EQBCT=cc4d79b347404b17a23de7b1fe386cd9