5 powerful Excel functions you are not using

You must have learnt SUM in your early days of Excel and later might have learnt about nested IF statements to do conditional sum and you might have already learnt about SUMIF and SUMIFS.

You think you can do everything with these functions without having a nervous breakdown? Lets put it to test and consider following data:

But there is a sum function that to me is as powerful as all these sum functions combined i.e. DSUM.

To learn about DSUM in detail with examples head over to this tutorial: Excel DSUM Function – “The” Sum function you MUST know