Does anyone know of a formula that can be used like sumproduct Only I have a huge range of data with certain criteria’s are met and instead of a sum of the numbers I need the formula to return the values. I have used concatenate and love this formula . The problem tho is it that only works when you are looking at the same column and rows within several sheets. I am looking for that same type of formula but I have certain criteria’s and a huge range of data.
As always that you for the help. ray:
As always that you for the help. ray: