Sumif is working for numeric values but can we do the same for text?

**vinsocf** · 02-06-2014, 03:39 AM

I have in sheet1

A B C

Name Date fee

rock 1/12/2013 100
brock 1/12/2013 200
sam 3/12/2013 150

after using sumif statement i coud arrange as below in a sheet2

A B C
Date Total Fee
1/12/2013 300 (sumif)

2/12/2013 0

3/12/2013 150

now in the c collum i need the result as

A B C
Date Total Fee
1/12/2013 300 (sumif) rock , brock

2/12/2013 0

3/12/2013 150 sam

How do we achive this !

**canapone** · 02-06-2014, 05:37 AM

Hi and welcome,

I think you're posting your question in the wrong section.

Regards

**FDibbins** · 02-06-2014, 02:59 PM

@ Canapone, Im not sure what you mean here...which section would you suggest?

@ vinsocf, welcome to the forum

Im not exactly sure what you want here

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic