Adding Formula

Afternoon, really appreciate it if someone could help. trying to come up with a formula that will add cells and give one total for different refs. For instance we have a spread sheet with part numbers in column A which appear in various rows down the spreadsheet and then in a different column there is the quantities for those refs. the bit I'm struggling with is I only want to count the ones without the word legacy which in another column.



So I would want to end up with only 5 for the ref A019 not 15 as there are 10 with the word legacy in the 4th column and only 2 of the ref A055 etc.

Hopefully that makes sense. It's only a very simple version of my spread sheet.

Look forward to someone's kind response.:Cry::Cry:

You can use COUNTIFS() to count based on multiple criteria.

e.g.

will result in 5 because in only counts A019 in column A where column D does not contain "Legacy".

You can replace the "A019" reference with cell reference containing the lookup value...

For Total Count value
For each individual Ref