Question Regarding Highline Excel 2016 Class 06:

[royalnass30]

on the AND page starting around 6:30 of the youtube video for Total COGS ($), Count Transactions, and Average Cost ($) when I put in the sumif, averagif, and countif formulas it is only giving me the answers for the 2 transaction that are true. Its not including the total sum of all the false transactions. For example, instead of getting 36 for my countif I only 2. Do you know why this would be happening sir?

 

[oldbrewer]

at least give us a link to the youtube video....

 

[royalnass30]

I figured it out. Thank you

 

[Joe4]

I see that this was the second question you asked on this video series.
In the future, if you have any other questions on the series, it would be best if you included a link to the video. The best way to get someone to help you is to make it easy for them to do so!