SUMIF formula for multiple "TEXTS"

[Pheels]

Some background on me. I am just learning Excel. Self teaching through tutorials online, the message board, and trial and error. I am trying to learn excel. I do not have much knowledge.

I will try to explain this as best I can

B4 is years
C4 is actual years
D4 is a text of EXT 1, EXT 2 or EXT 3. EXT 1 = the remaining years multiplied by 2. EXT 2 = remaining years multiplied by 3 and EXT 3 = rem yrs mul by 5

What I am looking to do is: when I type EXT 1 or EXT 2 etc, into Column D, that will multiply the corresonding number to B4, giving me the inout to C4.

EX: Type in EXT 2 into D4. That will multiply 3*the number of years in B4.

I hope this makes a lick of sense.
I will pre apologize for my lack of knowledge and ignorance.

Thanks

P

[Richard Buttrey]

Hi,

Welcome to the forum.

Can I suggest you upload your workbook and manually enter the calculated results so that we can see where we're aiming for with a little more clarity.

[Pheels]

B C D
YEARS Ext Yrs Extension
4) 2 4 EXT 1

5) 3
6) 1 EXT1


I get the SUMIF to work. =SUMIF(d4,"EXT 2",b4)*3. obviously, this does not help me when I enter in EXT 1 or 3.
Also, I do not know how to upload the workbook.

Thanks for the help

P

[Pheels]

Hopefully this works.

[Pheels]

I found a way around to make it work
I put the EXT in a column (L2, L3) and the corresponding number in a column (m2, M3).
How do I get the empty cells not to show false? I want them to be blank unless D is filled in.

=IF(D4=$L$2,B4*$M$2,IF(D4=$L$3,B4*$m$3))

[Pheels]

OK, found some information and did this

=IF(d4=$l$2,b4*$m$2,if(d4=$l$3,b4*$m$3,""))

that solved the "FALSE" within the cells.

If someone has a way that makes the worskeet not have the EXT off to the side on their own, i would appreciate if you could show me.
If not, no problem, this works. I like the worksheet to be minimal, if possible.

Thanks

P