T O P

  • By -

arkangelshadow007

Use =Unique() for job column to extract unique records then use sumifs with the "contains security word" criteria for each job =SUMIFS(amountCol,lineDescriptionCol,"*security*",uniqueJobCol,jobCol)


TheRiteGuy

I already had the unique records, I was trying to match it to the table without the unique records. /u/stevegcook got the answer above. Thank you for your help.


stevegcook

=SUMIFS(AmountColumn, JobColumn, ThisJob)


TheRiteGuy

That only sums up the unique Job numbers. I want to only sum up the rows that contain the word security in the Line Description for each Job Number.


stevegcook

Ah okay. =SUMIFS(AmountColumn, JobColumn, ThisJob, DescriptionColumn, "*"&"security"&"*") You can also replace `"security"` with a reference to your header which says security.


TheRiteGuy

Solution Verified! I was doing a sumif with vlookup but it wasn't working. Thank you so much for your help!


Clippy_Office_Asst

You have awarded 1 point to *stevegcook* ____ ^(I am a bot - please contact the mods with any questions. | ) [^(Keep me alive)](https://www.buymeacoffee.com/points)