Based on this
Quote:
Originally Posted by wilderness
Col A is date of completion
Col B offers a mere name for four different data sources
Col C is date of publication (source)
Col D is number of text documents
Col E is number of images.
|
your sum-range is wrong. You are summing B1:B210 instead of D1to D210
SUMIFS( sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n] )
Quote:
=SUM(SUMIFS(B1:B210,D1210,"ABHZ",C1:C210,"*1970* "))
|
should be =SUMIFS(D1
210,B1:B210,"ABHZ",C1:C210,"*1970* "))
sum_range and range are reversed between SUMIF and SIMIFS