Formulas

[tweetyrm]

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:

 

[TommyGun]

Can you post some of this "huge" range of data using the HTMLMaker AddIn?

 

[just_jon]

Along with what TG has asked, what types of data are you trying to use as key values? Dates, numerics, text... and are the matching columns in the big array sorted? Could they be?

 

[Smitty]

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

Jon and Tommy's comments notwithstanding, you can concatenate across multiple sheets, rows, columns, etc., using &.. I.E.

=Sheet1!A1&Sheet2!B2&Sheet3!C3

Smitty