mtk5200✭✭

That worked! Thanks!

Okay, I now saved it as a new report and it is summing but won't put it in Currency format. The column is only coming from one sheet and the entire column is formatted to Currency. Any ideas?

Thanks! This took care of it.

Hi @Genevieve P. Is it possible to use =Join(Collect to bring back multiple values but instead of a comma delimited list, have the values populate in the same column on separate rows? I've using join/collect in conjunction with a 'Text to Columns' option like excel and it doesn't appear to be an option. I'm trying to pull…