Should be at least 200 words but no more than 400 words.
You are chatting with a colleague who mentions that the SUBTOTAL function performs sum, average, count or other functions and questions why a person would use that function when the SUM, AVERAGE and COUNT functions already exist. What is the difference when using the SUBTOTAL to sum data versus the SUM function?