Hi Guys, this is my first post after 2 yrs as silent student ?
I have some question how to get the same result by using SUMIFS vs SUBTOTAL 9
The case is: I am set filter from 3 different columns and the subtotal 9 sum the rest of the number is 10,000,000. However, if I use formula SUMIFS with the same filter, the result not same
Formula
=SUMIFS(AB:AB,E:E,"OK",F:F,"ONSITE",H:H,"HRS") result formula 9,200,000
by using filters with same key in columns E, F & H the SUBTOTAL result above top line of cell is 10,000,000 there GAP around 800,000
may be the right Question is : How to use Subtotal 9 with condition
I have some question how to get the same result by using SUMIFS vs SUBTOTAL 9
The case is: I am set filter from 3 different columns and the subtotal 9 sum the rest of the number is 10,000,000. However, if I use formula SUMIFS with the same filter, the result not same
Formula
=SUMIFS(AB:AB,E:E,"OK",F:F,"ONSITE",H:H,"HRS") result formula 9,200,000
by using filters with same key in columns E, F & H the SUBTOTAL result above top line of cell is 10,000,000 there GAP around 800,000
may be the right Question is : How to use Subtotal 9 with condition