In some cases you need to first multiply qty and rate to get amount then you sum each amount to get grand total.
By using Sumproduct formula you can directly get Grand total without multiplying rate and Qty then summing it.
Search answer of the below queries
Excel Sumproduct function
Sumproduct formula in excel
how to use Sumproduct in excel
Direct grand total using Sumproduct formula in excel
Make your Digital Visiting Card https://mydvc.info/
Quora link https://www.quora.com/profile/Abhishek-Pandey-328
You can watch and learn from the below videos also.
Excel SUMIFS alternate DSUM function in Excel DSUM function in Excel in Hindi
Vlookup image in Excel picture lookup technique in Excel picture lookup Hindi image lookup
Convert number to Hindi words in Excel / Spell number in Hindi / Devnagari words in Excel
Convert Numbers/currency to Words (Rs, Dollar, Any currency) formula in Excel Excel Spell number
Take the opportunity to connect and share this video with your friends and family if you find it useful.