How To Use Sumproduct If Function In Excel [Formula Tip]

Hidden Treasure of Sumproduct IF In Excel

Yesterday, when one of my subscribers ask me for help about her problem which she was facing. All she needed was to combine SUMPRODUCT IF Functions to get data from a table. She was trying hard to create a formula but unfortunately she was unable to sort out her problem. While solving her problem I have learned a new thing to create SUMPRODUCT IF Statement.