Sum total row amount matched with date and store code and paste into another excel sheet

Help Activities
, ,
#1

hi,
i have storelist.xlsx in that columns names like Total row amount |Store code| Date processed by Bot
if date and store code same match sum total row amount and paste into another excel-2 of date row match.
how to calculate this can any one help this.

excel-2.xlsx (7.8 KB) storelist.xlsx (9.3 KB) is

#2

Hi @Anand_Designer
Did u mean if the date of both excel files match we had to add the Total row amount there in excel-2.xlsx ?

is it right?

#3

yes, but should match store code and date from excel-1. then sum total row amount and paste into excel-2.xlsx

#4

Hi @Anand_Designer

Check this workflow
sample workflow.zip (2.0 MB)

Regards

Nived N

Happy Automation

#5

image
image1366×768 98.4 KB

mean-- store Code s207 and date 09-28-2020 both matched
then total row amount sum s207 ==278.31 paste into excel-2 .xlsx that date

IF S209 Date-9-29-2020 both are same sum total S209 total amount=983+312=1295 and paste into excel-2.xlsx that date

#6

Did this Workflow satisfied ur query?

#7

Thanks for given Solution to me @NIVED_NAMBIAR

1 Like
#8

i have another query for this… can do sum store code wise without compare date

mean i need not compare two excel date. only use store.xlsx sum store wise amount , use that variable in log message…i
can you give solution this way ?

#9

This topic was automatically closed 3 days after the last reply. New replies are no longer allowed.