excel help needed please

[Smee]

Morning.

Would someone please tell me where I've gone wrong with this please

=SUMIF(C4:AE4,"Y", AND(c27:ae27)"2B"/F46

 

I'm "trying" to find cells that have "y" and "2B" and then divide by F46 but i think I've got myself in a pickle (also known as not very good with excel!)

 

thanks in advance

[Bedders]

Hi Smee,

 

I presume when you say that you're trying to find cells that have 'Y' and '2B' in them, you're adding up another column? If you use the Function Builder in Excel (In Excel 2013, it's under the Functions tab, then click on Insert Function) it'll show you what you have for each 'option' available for that function.

[Seb1780]

I think you need SUMIFS

 

SUMIFS(sum_range, criteria_range1, criteria1,[criteria_range2, criteria2],...)