There are several ways to get this information: 
  1. Create a new Constituent Profile.
  2. On the Profile Contents tab, select Gift Summary and any other appropriate information.
  3. Preview the report. The Years Giving appears in the Gift Summary section.
Note: This prints one constituent per page. To print multiple constituents per page, follow the instructions below.

OR
  1. Create a constituent export and export in XLS or CSV format.
  2. On the Output tab, select Constituent Information, Sort Key.
  3. Then select Gifts, Amount. The Gifts Criteria screen appears. For the number of Gifts to export select 1. Enter the date range for the first year and click OK.
  4. At the top of the Output window in bold letters is the name of your export (for an unsaved export it reads New Constituent Export). Click that word. Select Gifts, Amount and the Gifts Criteria screen appears again. Select the date range for the second year and click OK. Report for each date range needed.
  5. Export and open the file in Excel.
  6. In the first row of data, place your cursor in the first blank column and add the count function to count the columns with an amount for each constituent. For example, in cell A1 is the first constituent's name. In cells B1 to E1 are the gift amounts. If a constituent does not have any gifts in a particular year, that cell is blank.
  7. To add the count, in cell F1, enter: =COUNT(B1:E1).
  8. Copy cell F1 all the way down.

OR try this Alternative  (Thanks to Maria Kramer of Lutheran Social Services of South Dakota for sharing this option)

Please NOTE: This process is outside the scope of Blackbaud Support because it involves working within Excel to manipulate the report to get the desired results.
This process will not be suitable for trying to do an import of this data back into The Raiser's Edge without additional manipulation depending on the format of your results.
  1. Create a new Constituent Profile.
  2. On the Profile Contents tab, only select Constituent Name and Gift Summary. Include Preferred Address.
  3. Preview the report. The Years Giving appears in the Gift Summary section.
  4. Export the report in Excel 8.0 (Extended) format. Mark the Column Headings and Use Worksheet functions to represent subtotal fields in report checkboxes. In the Set column width field, select Constant column width with a value of '8.'. In the Format field, select Non-Tabular format. Click OK and save the export file.
  5. Open the export file in Excel.
  6. Delete the first five rows.
  7. Right-click the Constituent Profiles tab and select Move or Copy. Highlight Constituent Profiles and mark the Create a copy checkbox to create a copy of this worksheet before making any additional changes.
  8. Select the Constituent Profiles (2) worksheet.
  9. Press the CTRL key and select rows B-D, F, and H-L on the Constituent Profiles (2) worksheet.
  10. Right-click the highlighted columns and select Delete.
  11. Select Edit, Replace. The Find and Replace window appears. Enter each of the following fields one by one in the Find what field and leave the Replace with field blank to replace all fields with a blank and Click Replace All:
    • Constituent name
    • Gift Summary
    • First
    • Latest
    • *Greatest
    • Average:
    • Median:
    • Breakdown
    • Calendar year
    • <All>
    • Amount
    • Fund
    • Pledged
    • Paid
    • Balance
    • //
    • Your format the date is in (ie. 1/200*-12/200*)
    • Your format the date is in for prior to (ie. 01/200*)
    • Your format the date is in for after (ie. 12/200*)
  12. Highlight column B.
  13. Select Edit, Replace. Enter $* in the Find what field and leave the Replace with field blank to replace all the fields with a blank and click Replace All.
  14. Highlight column C and select Edit, Replace. Enter *.* in the Find what field and leave the Replace with field blank to replace all the fields with a blank and click Replace All.
  15. Highlight column C and select Edit, Replace. The Find and Replace window appears. Enter each of the following fields one by one in the Find what field. Click the Options button and mark the Match entire cell contents checkbox. Click Replace All to replace the following fields: Find Replace With 10 Ten 20 Twenty 30 Thirty 40 Forty 50 Fifty 60 Sixty
  16. Highlight column C and select Edit, Replace. Enter ***0 in the Find what field. Unmark the Match entire cell contents checkbox and leave the Replace with field blank to replace all the fields with a blank and click Replace All.
  17. Highlight column C and select Edit, Replace. The Find and Replace window appears. Enter each of the following fields one by one in the Find what field. Click the Options button and mark the Match entire cell contents checkbox. Click Replace All to replace the following fields: Find Replace With Ten 10 Twenty 20 Thirty 30 Forty 40 Fifty 50 Sixty 60
  18. Highlight columns B and C. Select Edit, Go To.
  19. Click the Special button.
  20. Select Blanks and click OK.
  21. Right-click the highlighted cells and click Delete. When prompted, select Shift cells up.
  22. Delete any unusual values such as dollar amounts in column C.
  23. Right-click the Constituent Profiles tab and select Move or Copy. Highlight Constituent Profiles and mark the Create a copy checkbox. Click OK.
  24. Select the Constituent Profiles (3) worksheet.
  25. Highlight column A and select Data, Filter, Advanced Filter. Click OK.
  26. On the Advanced Filter window, mark the Filter the list, in-place option. Mark the Unique Records Only checkbox and click OK.
  27. Right-click column A and select Copy.
  28. Select the Constituent Profiles (2) worksheet.
  29. Right-click column A and select Paste.
  30. Delete cells A1 and A2.
  31. Verify there are no names in column A as duplicates. If there are, delete the cells and select the Shift cells up option.
  32. Print the report