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.
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.