**PERFECT SOLUTION: =SUMPRODUCT()**formula that I had no clue about (Thanks Skip Vought .. and all the others who helped). This formula was used on 2 worksheets, one that totals the purchase by the “Type” column and another by “Resource” and the formula I’m using is

**=SUMPRODUCT(('!_Library'!A:A=A4)*('!_Library'!G:G))**These 2 sheets are not included in the upload but trust me, it works.

=============================

**Attached is a small sample of my “Library” worksheet with the data related to this inquiry. not the entire workbook.- for Privacy purposes.**

**NOTE:**I do not know VBA or how to implement it. I do not feel it is fair for me to ask for a tutorial on how to implement such a thing, that’s why I hope this can be done via Formula/Function within Excel 365.

If not, I’m happy to learn but if its too involving, I’ll probably get lost.

**============================**

HYPERLINKS:

HYPERLINKS:

I have a column of Hyperlinks,

**(See Column M)**have long links (from a data dump) that I’d like to simplify by using the word “Link”. I copied that column to outside of my prime data, and in its place entered the following formula:

**=HYPERLINK(cellref,”Link”)**and was ELATED that it worked! I then used the following a

*Copy > Paste Special > Values*on the

**“Link”**s

**(Column K)**hoping to have the hyperlink show just the word

**Link**then delete (Column M), OOPS… the links don’t work (which I understand the data is now gone)..makes sense. I just don’t understand why it won’t allow me to use

*Paste > Special >Values*. What am I doing wrong?

This is very tedius work updating each link to reflect the word “

**Link**” by manually editing them all through the Hyperlink or Link option within excel. My list of just over 6,500 records and ever growing. I have been doing this work manually but I still have 5,189 links yet to do I’m hoping this can be done a little easier. Currently when adding data, I fix them manually from the entry point but there are SO MANY to edit from the past.

**============================**

TOTALS SPENT BY CRITERIAL: Yearly & Quarterly

TOTALS SPENT BY CRITERIAL: Yearly & Quarterly

If you have a column of DATES, you could get these totals by YEAR or by QUARTER or by whatever other discriminatory category you might have in your data, that might help you give a clear interpretation of your data."

It was suggested there may be a way, if I use dates in my information to utilize, the “Date” I’d want to use is

**Column G: Date Added**

These dates range from 1991 to Present. The purpose for this workbook is Inventory as well as over the last 51 years, how much I have spent on my craft (Crocheting). So this would be extremely helpful.

Too much to ask?

I appreciate any and all recommendations or assistance

Laurie