NAV Report - How To Use Excel SUMIF Function?
Hi all,
I think most of us know SUMIF Function IN Excel, Those who don't know below is a sample.
Suppose i Export my Item Ledger Entries Data in Excel. Now i want to see the Total Quantity Sum where Entry Type Is Sales or Purchase.
There are two ways to achieve same -
1. I Filter the Data based on Entry Type and Sum up Quantity.
2. Or I Can Use SumIF Excel Function where i can put a condition.
Read Complete Article »
I think most of us know SUMIF Function IN Excel, Those who don't know below is a sample.
Suppose i Export my Item Ledger Entries Data in Excel. Now i want to see the Total Quantity Sum where Entry Type Is Sales or Purchase.
There are two ways to achieve same -
1. I Filter the Data based on Entry Type and Sum up Quantity.
2. Or I Can Use SumIF Excel Function where i can put a condition.