Quote:
Originally Posted by wilderness
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./
|
I'm still a little confused but I'll look at this more closely and see if I can figure it out.
As for begins with, you can get something similar by using RIGHT.
IF A1 is 01012017, RIGHT(A1,4) would give you 2017.
