I'm using Office 2010 and I know there is a function called sumifs which is used to for calculation, however my company is using Office XP and wonder is there any similar thing of it? Or, is there any VBA code that can serves similar thing?
Here's a practical example:
The equivalent SUMPRODUCT would be:
This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results.
Paraphrasing Richard Shockley, author of my favourite finance reference tex…
Excel can be a tricky bit of software to get your head around. Whilst you’ll be able to eventually get to grips with the basic understanding of how to get by, there are a few Excel tips that not everybody will even know about let alone know how to d…