how can i get total if data is in same row
By rraushan2088@gmail.com on Thursday, 08 December 2022
Posted in Excel
Replies 3
Likes 0
Views 4.3K
Votes 0
i want to set formula in excel which data is below please help me to set formula ....i have attached excel sheet also.
---------------------------------------------------------------------------------
RECV DATE | RCV. CH. NO | RECV | RECV DATE | RCV. CH. NO | RECV |
---------------------------------------------------------------------------------
02-Aug | 1362 | 717 | 02-Aug | 1366 | 612 |
---------------------------------------------------------------------------------

my data is in column wise and i want datewise total sum of "RECV" values ...

please help me
Hi there,

Sorry for the late reply.

Since your data is in column wise, you will have to nest some formulas together:

In the cell O4, the formula can be: =SUM(SUM(FILTER(F4:F6,D4:D6=N4,0)),SUM(FILTER(I4:I6,G4:G6=N4,0)),SUM(FILTER(L4:L6,J4:J6=N4,0)))
In the cell O5, the formula can be: =SUM(SUM(FILTER(F4:F6,D4:D6=N5,0)),SUM(FILTER(I4:I6,G4:G6=N5,0)),SUM(FILTER(L4:L6,J4:J6=N5,0)))
In the cell P4, the formula can be: =TEXTJOIN(",",TRUE,TEXTJOIN(",",TRUE,FILTER(E4:E6,D4:D6=N4,"")),TEXTJOIN(",",TRUE,FILTER(H4:H6,G4:G6=N4,"")),TEXTJOIN(",",TRUE,FILTER(K4:K6,J4:J6=N4,"")))
In the cell P5, the formula can be: =TEXTJOIN(",",TRUE,TEXTJOIN(",",TRUE,FILTER(E4:E6,D4:D6=N5,"")),TEXTJOIN(",",TRUE,FILTER(H4:H6,G4:G6=N5,"")),TEXTJOIN(",",TRUE,FILTER(K4:K6,J4:J6=N5,"")))

Please give it a try.

Amanda
Amanda Lee
·
1 year ago
·
0 Likes
·
-1 Votes
·
0 Comments
·
HI,
Thanks for your reply...really awesome formula you are using in it....but it is not much more useful ...resion behind of it ....here no. of column is not fixed..it can increase any time....and secondary resion is no one is using ms office 360 or upgraded version....here all have only ms office 2013 and in this text joint formula is not avilable.....so please suggest another formula which is capable for ms 2013...
rraushan2088@gmail.com
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi there,

If the number of columns is not fixed, then I'm afraid it's not gonna work with formulas...

Amanda
Amanda Lee
·
1 year ago
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post