How to Sum (Distinct Value Column 1 * the Qty in the same Row) + the Count of distinct in Column1

Paul Newcome

In your most recent screenshots, it looks like the [Siflex Cost] and [20% Cost] columns are blank there in the formula sheet. If you are matching on those columns, you need to have data to match with.

T C

I was trying to display the values from the [Amperage], [SiFlex], and [20% Cost] Columns in the "Breakers and Costs" Sheet to the "SieFlex Cost Summary" Sheet. With respect to/Matched to the "Items Being Added" Column values.

Is there a different approach I should be using?

Paul Newcome

For those columns you can use an INDEX/MATCH.

=INDEX({Reference Sheet Column To Pull}, MATCH([Column To Match On]@row, {Reference Sheet Column TO Match In}, 0))

T C

Thank you @Paul Newcome for helping me with this. I am very grateful! This new formula worked like a charm!

Also, thank you @Andrée Starå for your insight!

Paul Newcome

Happy to help. 👍️

Andrée Starå

@T C

You're more than welcome!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!