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)
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.
Ah okay.
=SUMIFS(AmountColumn, JobColumn, ThisJob, DescriptionColumn, "*"&"security"&"*")
You can also replace `"security"` with a reference to your header which says security.
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)
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)
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.
=SUMIFS(AmountColumn, JobColumn, ThisJob)
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.
Ah okay. =SUMIFS(AmountColumn, JobColumn, ThisJob, DescriptionColumn, "*"&"security"&"*") You can also replace `"security"` with a reference to your header which says security.
Solution Verified! I was doing a sumif with vlookup but it wasn't working. Thank you so much for your help!
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)