What does #value mean in Excel Sumifs?
What does #value mean in Excel Sumifs? Normally a #VALUE error means that one of the references is not a true value in Excel (perhaps has a space in it or is a word) but in this case the reason is different and more importantly it acts differently to the normal SUMIF. How do I […]