What value would be returned based on the formula in Cells B47:E47?
The Correct Answer is (D) 186.
Sumifs formula uses when you have many condition and you want to get the total if those conditions satisfied.
You want to get the total of expenditure if count is more than 3 (>3) and if category starts from "HOU*".
This * of HOU indicates next letters are whatever.