Hi, hoping someone can help.
This is a view of my "Pipeline Sheet" In column B I have a range of products, example showing "OAB" from the dropdown menu. Column C will represent leads relevant to whatever product type I have selected in "B".
At the bottom I have another sheet called "Data Overview" in here I want to pull through data from my "Pipeline View". For example if the Product selected is "OAB" I would want it to add up all of column C leads associated to that product type from the dropdown menu the "Pipeline sheet"
Hope that makes, is it possible?
EDIT:
This is in Google Sheets
This is a view of my "Pipeline Sheet" In column B I have a range of products, example showing "OAB" from the dropdown menu. Column C will represent leads relevant to whatever product type I have selected in "B".
At the bottom I have another sheet called "Data Overview" in here I want to pull through data from my "Pipeline View". For example if the Product selected is "OAB" I would want it to add up all of column C leads associated to that product type from the dropdown menu the "Pipeline sheet"
Hope that makes, is it possible?
EDIT:
This is in Google Sheets
Last edited by a moderator: