hi all small formula issue can anyone help got the basics can add, multiply, ect copy columns, but need a multiple column (sum) entry.
Row
a item £ sorted
b total £ sum of h-P (sorted) H-P x a = B all good
Column
1-200 some headings but overall
so I need
H1 - H200 column H x A But for the...