Hi,

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.

Thanks in Advance.

Anuradha P.