I'm lost, please help.

I'm trying to write a formula that will look at a sheet within the document and report back to another sheet.

Any help you can give me would be greatly appreciated.

Thanks again for any help.


One more attachment.

Steve

See attached for the first file.

In the future please use a different post if you are asking for help on an unrelated problem.

- Clay Ver Valen
Excel Help

Second file with solution is attached.

- Clay Ver Valen
Excel Help

Clay

Thank you so much for your help with my formulas.
I just have one more question. What formula would I need to total up the purchases within a certain criteria.

I don’t know how to write a formula to fill in the green info.

Thanks again.

Steve