I've a simple five column sheet (six if you count the 'notes column.
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.
What I'm attempting to SUM is:
Col B is 'ABHZ' and Col C contains 1970 (note there will eventually be 1970 thru 1984 dates in this column) as the criteria,
while SUM for the item counts in both D & E (using above criteria).
FWIW; these are photo negatives and I simply wish a count by each year rather than an solitary overall count that I've already in place.
NOTE; these sums/counts are placed at the bottom of the sheet.
It's worth noting that Excel offers a 'begins with' option for data, however in this instance an 'ends with' (not available) would be ideal./
__________________
Best Don
Last edited by wilderness; 05-12-2018 at 04:59 PM.
|