All articles with 'database functions' Tag
{ 10 Comments }
Sum up neither “A” nor “B” values – How to use DSUM function in Excel [video]
Published on Jun 8, 2016 in Excel Howtos, Learn Excel
We know how to use SUMIFS function to answer questions like, “What is the sum of values for ‘A’?” But how would you answer questions like,
- What is the sum of values that are neither “A” nor “B”?
We can still use SUMIFS, but it will get awfully long. So let’s turn our attention to other functions in Excel.
Continue »