#1
|
|||
|
|||
Newbie Question?
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
|
#2
|
|||
|
|||
I have updated my question Thanks
|
#3
|
|||
|
|||
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 |
#4
|
||||
|
||||
Perhaps something like =SUMPRODUCT((LEFT($A$2:$A$24,3)="PF6")*$H$2:$Q$24)
__________________
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 |
#5
|
|||
|
|||
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!!!
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Newbie question on Word 2010 | sunalta | Word | 7 | 09-06-2012 12:49 PM |
Newbie Question | thistlebarrow | PowerPoint | 4 | 04-06-2012 01:46 PM |
newbie question | DanSandbergUCONN | Word | 5 | 03-06-2011 04:27 PM |
Newbie to Powerpoint question | Phil66 | PowerPoint | 9 | 06-01-2010 10:51 AM |
Perhaps a newbie question I know but | as1947 | Excel | 0 | 02-05-2009 08:01 AM |