Hi,

I am doing a simple =SUMIFS formula to sum all the sales for a particular item but don't want to manually type in the item name.

formula is =SUMIFS(!A:A,!B:B,"text")

Column A is the qty of items sold
Column B is the list of various item sold which I am searching through
"text" is the item name I am searching for

For "item name" I have to manually enter this.

How do I reference this to a particular cell which contains the item name? This will allow me to avoid manually typing each item name in as the item list exists so I can drag this formula to repeat for all 100's of items.

Thanks