SUMIFS function won't give me a sum for 1 text criteria and date range
I have been trying to create a formula that will pull the sum of my various expenses/income according to the their category and within a month's range. Here is the formula I wrote: =SUMIFS('Transactions'!E:E,'Transactions'!C:C,'Gifts','Transactions'!A:A,'>='&'1'!G2,'Transactions'!A:A,'<='&'1'!H2) I want the sum to populate on the sheet named '1' and I'm having it pull the info from the sheet named 'Transactions,' which has a masterlist of all my transactions for the year (both income and expense) which includes the columns date, paymentmethod, type, description, and amount. I have data validated date, paymentmethod, type, and amount. Column E is amount, C is type (which includes 'Gifts'), and A is date. G2 and H2 are start date and end date which I typed out as 1/1/25 and 1/31/25. They are formatted as dates and data validated. Every time I press enter on this it just shows what I typed with red dotted lines around it. Other basic functions work (e.g. sum) but this one won't. Any idea how I can get this to work?
Error VBE6EXT.OLB
HolaWindows 10 home compilación 19045.5854, excel hoy presentó el error que no podía cargar "VBE6EXT.OLB" y si pincho en aceptar indica memoria insuficiente, también con un botón de aceptar. Intenté reparar la instalación (fuera de línea como a través de internet). Desinstalé y volví a instalar Microsoft 365. El problema persiste. Mi sistema tiene 32 GB, y funciona bien bajo carga, por lo que no es problema de memoria. Otras soluciones de internet que intenté fue limpiar la caché de excel y volver a registrar el archivo VBE6EXT.OLB, pero el problema persiste. ¿hay alguna otra forma de resolver la situación? Gracias. Daniel Castañeda Abarca
Excel (365 & 2016) with network information...and much more Information to Filter.
With Excel (365 & 2016) Network information, information about Local Network Connectivity, Test Connection to a Specific Web URL, WiFi SSID information ...and much more information to filter with a button. I was trying to create a tool that would allow me to filter the necessary information from all the PCs I need to work on using a USB stick. I came across an old file that I edited and added additional information to the code. I'd like to share this file (Help for self-help). If anyone finds it useful, or would like additional tips or information, please feel free to send me feedback. If it doesn't help you...just ignore it. I welcome any constructive comments. * After loading the file, be sure to activate all macros. Happy Excel-ing! 🙂
Macros being blocked in Excel even though file is located in trusted site
I am experiencing an issue that I have seen several discussions about, however there does not appear to be an answer so I wanted to see if anyone has found an answer for this. I have a user that is getting the following message in excel when opening a file on a network share: Microsoft has blocked macros from running because the source of this file is untrusted. I have confirmed that the file location is in the Trusted Center and in addition, this issue just started happening recently with no changes that I am aware of. I have also placed the server IP and Server name of the server in the Trusted sites under Internet Options, but this did not change the issue. Here is some info about the system: Windows 10 Pro 10.0.19045 Build 19045 Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20124) 64-bit
How to resolve formula discrepancy Excel/SharePoint
Good afternoon, could someone help me? The formula =IF(ISERROR(INDEX(Form1!F:F, ROW()-90)), "", IF(INDEX(Form1!F:F, ROW()-90) = "", "", INDEX(Form1!F:F, ROW()-90))) works in offline Excel, but in SharePoint/Excel Online it shows an error. It appears there is an error in the formula. I am using Portuguese in both versions.📣 ExcelAt40 – Days 5 to 10 Recap
Hello Excel Community 👋 I’ve been running a daily series called #ExcelAt40, celebrating 40 years of Microsoft Excel through stories, innovations, and personal reflections. Here’s a recap of Days 5 to 10 — each post dives into a pivotal moment in Excel’s evolution: Day 5: Charting the Future Before dashboards ruled the world, Excel gave us the power to visualize data with clarity https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-day-5-charting-the-future-activity-7364386306572828673-dpj8 🧠 Day 6: Formulas That Changed Everything From =SUM() to =XLOOKUP, Excel taught us how to reason with logic. https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-formulas-that-changed-everything-activity-7364968873474908161-PGNb 📈 Day 7: PivotTables Debut Celebrating Professor Pito Salas, the visionary behind dynamic data analysis. https://www.linkedin.com/posts/olufemi-olamoyegun_day-7-pivottables-debut-activity-7366077860282896384-euqr 🧬 Day 8: VBA Rises In 1997, Excel unlocked automation with Visual Basic for Applications. https://www.linkedin.com/posts/olufemi-olamoyegun_excelat40-day-8-vba-rises-activity-7366342708942008320-yJL7 🧩 Day 9: The Ribbon UI Revolution Excel 2007 introduced the Ribbon a bold redesign that changed how we work. https://www.linkedin.com/posts/olufemi-olamoyegun_day-9-the-ribbon-ui-revolution-activity-7367783381973053440-I-KK 🛡️ Day 10: Y2K Audits Excel’s role in averting global disaster during the Y2K crisis. https://www.linkedin.com/posts/olufemi-olamoyegun_y2k-audits-activity-7367795370120187904-5ewY I will love to hear your thoughts: 💬 Which Excel feature changed the way you work? 📌 What’s your favorite moment in spreadsheet history? Let’s celebrate the legacy together. #ExcelAt40 #MicrosoftExcel #OlufemiBuilds #NoCode #TechLegacy #ExcelCommunityApplying a Border via Conditional Formatting
Hello All Excelers, On a worksheet in Column A I have a set of names, in Column B have a set of dates, and in Column C I have a set of values. The values in Column C have some Conditional Formatting (CF) to indicate the highest 3 values. The CF will make a red boarder around the cell, and make the interior cell color blue. I want to make a CF (or anything else) that would make a red boarder and interior cell color blue for the rows in Columns A and B. Any ideas? Thanks GiGi
