Highline Excel 2016 Class 05: Excel Array Formulas: Comprehensive Lesson

[royalnass30]

I have a question regarding Array Formula 6 around the 29:00 mark in the youtube video. I put in all 3 formulas for sales team 1 and the only answers that I got was 0 and the total autosum for the for the entire sales table. I am just trying to get sales team 1 total sales. I will great appreciate some help with this question. Thank you and have a great day!

 

[Jerry Sullivan]

Welcome to MrExcel,

Did you download the example workbook through the link under the video?

The example workbook already has the formula, and that worked for me.

I'm not sure what you mean by "I put all 3 formulas for sales team 1", since there are only 2 formulas demonstrated in the video. (one that adds 4 Sumifs expressions, and one that uses Sumproduct).

 

[royalnass30]

Welcome to MrExcel,

Did you download the example workbook through the link under the video?

The example workbook already has the formula, and that worked for me.

I'm not sure what you mean by "I put all 3 formulas for sales team 1", since there are only 2 formulas demonstrated in the video. (one that adds 4 Sumifs expressions, and one that uses Sumproduct).

Okay I will download the workbook and try it again. I will let you know if I get it correct.

 

[Aladin Akyurek]

Okay I will download the workbook and try it again. I will let you know if I get it correct.

You can forward the questions presumably also where this video has been published.