Sum If & contains

Tim N

Hi, Hoping for some help with a Sum IF formula. I would like to sum if from 'Sheet 2' Value based on Sheet 1 project code. I have tried the below formula utilising 'Contains' however it is returning 0 rather than sum of project 304.

Sheet 1

Sheet 2

Any assistance would be appreciated

jmyzk_cloudsmart_jp

Hi @Tim N

Try this;

=SUMIF({Data Shuttle Report Range 1}, CONTAINS([Primary Column]@row, @cell), {Data Shuttle Report Range 2})

You need to use this format for the SUMIF function.

SUMIF(range, criterion, [sum_range])

range: {Data Shuttle Report Range 1}

criterion: CONTAINS([Primary Column]@row, @cell)

[sum_range]: {Data Shuttle Report Range 2}

https://help.smartsheet.com/function/sumif

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

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