Total of Rows for any particular Text

**abhishek_singhal** · 06-16-2018, 03:17 AM

Hello

Please help me with writing a macro for adding the cost on daily basis for any particular text. Please review the attached sreenshot:

1.png

Thanks in advance.

Abhishek

**alansidman** · 06-16-2018, 04:06 AM

Your explanation lacks sufficient detail to provide a solution. Please explain exactly what you wish to happen using your example. We are excel experts here but we lack mind reading skills.

**abhishek_singhal** · 06-17-2018, 02:43 PM

Hi Alan

Sorry for that. What I am looking for adding cost daywise on the basis of increasing days. Look at Desired Results column and Formula used in the next column. Hope that make it more clear otherwise I will try to find something else.

Thanks
Abhishek

**Fluff13** · 06-17-2018, 02:50 PM

How about
=IF(C1="","",SUMIF(A$1:A1,A1,C$1:C1))

Total of Rows for any particular Text

LinkBack

Thread Tools

Rate This Thread

Display

Total of Rows for any particular Text

Re: Total of Rows for any particular Text

Re: Total of Rows for any particular Text

Re: Total of Rows for any particular Text

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Automatic remove rows where Doc.Header text total is Zero ( 0)

copy selected rows(Check boxes) & Auto insert Sub Total & Grand Total option with Formula

[SOLVED] VBA to add up Total # or rows to populate Destination sheet and insert More Rows if needed

Combine Excel Sheets (+2 Million Rows total) and Create Pipe Delimited TEXT File

[SOLVED] Macro to insert blank rows so that the total number of rows with data is equal to 1021

Delete Rows that Contain the Text "Total" and vice versa

[SOLVED] Add total number of rows (text) in a column

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions