SUMIF With Condition and For Filter Result Only (Not Include Hidden Row)

[hazrultaib]

I want to SUM the price(E) only if the Status(G) is completed. But I want to sum only for filter result for Quater 3 (July - September). Not include the hidden row. Please help.

[#2 · Accepted solution]

@hazrultaib 

Here is step by step instruction https://www.youtube.com/watch?v=9Zam8iv8TUc

[#3]

@Sergei Baklan thank you. problem solved

[#4]

@hazrultaib , you are welcome