Do I need sumif/sumproduct/if? not sure Newbie

[wwiii]

Hi,

Very new to excel. I have managed to manipulate a template to meet most of my needs, save one.

On Sheet1 I need to multiply B1*10 if and only if F1 is found in sheet 3 or named list.

i have been searching here and elsewhere for quite some time but have yet to find the solution to what i thought was simple task.

Obviously the formula below does not work but thought it may help make it clear what i want to do

=IF(F11=Cases!$B$2:$B$34,B11*10,5)

i have tried so many forms of if, sumif, sumproduct that i can't remember them all. isn't this a pretty simple thing to do?

Would be very greatful for any help. thx

 

[dave3009]

Hi and Welcome

Perhaps
=IF(COUNTIF(Cases!$B$2:$B$34, F11), B11*10, 5)

 

[wwiii]

wow that was an incredibly fast response thx.

that does work but i failed to mention in my first post i need this to work down the entire column so i guess what i need would be closer to

cell H11 =IF(F11:F22=Cases!$B$2:$B$34,B11*10,5)

 

[wwiii]

thought maybe this would help

 

[Aladin Akyurek]

Try...

=SUMPRODUCT(SUMIF($B$11:$B$13,List,$F$11:$F$13))*10

List stands for the list of items on Sheet3...

 

[wwiii]

i tried that but no luck
i entered =SUMPRODUCT(SUMIF($B$11:$B$13,Cases,$F$11:$F$13))*10

thx for your suggestion tough

 

[sailepaty]

Maybe,

=SUMPRODUCT(SUMIF($F$11:$F$13,Cases,$B$11:$B$13))*10

Regards

 

[wwiii]

that's it! thx much sailepaty

 

[sailepaty]

The credit goes to Aladin, it was only a typo in his answer.

Regards