I’m trying to apply SUMIF formula for multiple columns that are in different excel sheets.

Below is the SUMIF formula I’m trying to apply.

=SUMIF(Revenue!E:E,Summary!A2,Revenue!AE:AE)

Here “Revenue” is a different sheet where we are looking entire Column’s-“E” & “AE”.
“Summary” is a different sheet where we are using the Column Cell - “A2” and write the SUMIF value in Summary Sheet - column Index =4.

Can you please suggest any idea how I can read 2 excels and apply SUMIF formula for both the sheets.
Below are the sample excel sheet screenshots.

Yes…I’m able to apply the formula(=SUMIF(Revenue!E:E,Summary!A2,Revenue!AE:AE)) manually and getting the data. Below is Output value which I’m writing in the column -E(Summary Sheet).

I need to download the multiple excels , filter with specified data and then make a consolidated sheet where applying VlookUp and SUMIF for many column’s of data. and output data has to be appended in summary sheet based on each run.

Soo i think Creating a macro in excel and applying formula would make it complicate. Can you please suggest any other idea?.

I have an idea to write the formula in Write Cell. But here i’m referring 2 column’s from 1 sheet and other 2 column’s from another sheet. and that’s where i’m stuck how to write the condition for 2 sheets.

I’m storing the 2 sheets of data in 2 Data tables.but not getting any idea to write the formula - =SUMIF(Revenue!E:E,Summary!A2,Revenue!AE:AE)

the Column Name - “Sales Order” is common in both summary sheet and revenue sheet.

So i’m reading the both data tables and fetching the column"Sales Order" data - and assigning to a data row. Now for item in DataRow…I’m applying the below formula to sum the Amount(Column -AE) of each sales order which is in the range(E Column in Revenue sheet).
So instead of giving the sum value, it’s returing 0.

Can you please check the Workflow and the excel sheet and help me?

The formula must be applied to the excel and not the datarow/datatable… but if you need to use the result of the formula being applied in a process, then i think we should go with a different approach…

I wrote the formula that we actually enter manually in write cell and tired running… But it didn’t give any output…
That’s why assigned the conditions and tried to show the output in message box before writing it in excel. Can you please refer to the excel