I have a spreadsheet in 2007 that contains 3 columns of data that need to be analyzed. The first column is a date, the second column is either an “x” or blank, the third column is either a “yes”, “no”, or blank.
What I need to perform is the following:
1) Review the first column to see if it has a value that is in the date range of the year 2013, then sum up all of the 2013 values.
2) Review the second column to see if it has an “x”, and only sum up the “x” value against the first row that has a value of 2013.
3) Review the third column to see if it has a “yes”, and only sum up the “yes” value against the first row that has a value of 2013.
I’m sure the formula for my last two requests will be very similar in nature, but those are the ones I’m struggling with the most. I have been able to accomplish the first operation fairly successfully with the following formula:
=SUMPRODUCT(--(YEAR($A$2:$A$3000)=2013))
But incorporating this into the next two formulas has not worked in any of my attempts.
If anyone has any suggestions I would greatly appreciate them. Also, if there is an easier way to accomplish the first task, I’m all ears.
Many thanks.
Bookmarks