maybe
Here's how the formula works:- SUMIFS is used to calculate the sum of values from column E (Assuming it contains numerical values) in Sheet2 that meet the specified criteria.
- Sheet2!E:E refers to the entire column E in Sheet2.
- Sheet2!G:G refers to the entire column G in Sheet2.
- "*Rent/mortgage*" is the criteria being searched for. The asterisks (*) act as wildcards to match any text containing "Rent/mortgage" anywhere within the cell.
- SUMIFS(Sheet2!E:E,Sheet2!G:G,"*Rent/mortgage*") calculates the sum of values from column E in Sheet2 where column G contains "Rent/mortgage".
- Similarly, SUMIFS(Sheet2!F:F,Sheet2!G:G,"*Rent/mortgage*") calculates the sum of values from column F in Sheet2 where column G contains "Rent/mortgage".
- The two SUMIFS functions are added together using the + operator to get the total sum.
Make sure to replace "Sheet2" with the actual name of your sheet containing the data.
Bookmarks