Merging cells/totals

Hi Pennie,

Thank you for the response. Please find a formula below which will concatenate the product with the two totals. This is the sample data I used.

Beans 23 £4.56
beans 45 £7.89
beans 58 £6.59
Burgers 67 £3.56

A1&" "&SUMIF(A1:C4,"Beans",B1:B4)
&" " & SUMIF(A1:C4,"Beans",C1:C4)
The & is used to join separate cell values. The Speech marks with a space represents a space between each value

Cell A1 contains Beans. SumIf function is saying using the data range a1:c4, find the criteria of Beans and the third and final argument is the Sum Range which is the list of numbers.

I hope this makes sense.

Regards

Simon

Hi Pennie,

Update on formula including concatenating £ sign before the total cost.

=A1&" "&SUMIF(A1:C3,"Beans",B1:B3)&" "& "£" &SUMIF(A1:C3,"Beans",C1:C3)

Hope this resolves your question.

Let me know.

Regards

Simon

Hi Pennie,

Slightly confused now as the last answer posted doesn't total the figures for each product.

I thought you wanted to add the quantities together for the beans product and the costs for the bean product.

I will send you the spreadsheet I created to show you how I did it.

If this is not the result you were looking for could you please reply and clarify with more detail perhaps using the spreadsheet I am sending you.

Regards

Simon

Hi Pennie,

Can you please let me know if your Forum Post is now resolved.

Looking forward to your reponse.

Regards

Simon