Hi, I don't really know how to ask this as I am not too sure on the Excel Terms. I want to be able to find all the words that begin with the first 3 letters and or Space, then I want to be able to calculate the sum of the cells link to that cell, I have attach a sample to clarify I hope LOL What I mean. Thanks

Attached Files

EXAMPLE OF ITEM LIST.xls (456.5 KB, 10 views)

I have updated my question Thanks

Attached Files

EXAMPLE OF ITEM LIST.xls (457.0 KB, 12 views)

I have looked at your sheet and I can't puzzle out what words you are referring to.

But what you probably need to do is something along the line of

=Left(A1;3) which will give you the first three characters of the referenced cell.

Then you need to combine that with a SUMIF function.

/Møller

Perhaps something like =SUMPRODUCT((LEFT($A$2:$A$24,3)="PF6")*$H$2:$Q$24)

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Thanks for all your help everyone, I used Pecoflyer's formula and it is exactly what I needed, sorry that it was so vague I will learn the proper lingo soon enough. Thanks again!!!