أفضل ذكاء اصطناعي لـ Write Excel formulas
Generate complex Excel formulas — VLOOKUPs, SUMIFS, INDEX-MATCH, array formulas — from a plain English description, with explanations.
ChatGPT
ChatGPT with Advanced Data Analysis can actually run Python on your uploaded spreadsheet and verify the formula works — not just guess at it. For pure formula generation, it also gets edge cases (date formats, exact text matching) right more often than competitors.
افتح ChatGPTI have a spreadsheet with these columns: A: [COLUMN A DESCRIPTION] B: [COLUMN B DESCRIPTION] C: [COLUMN C DESCRIPTION] [add more as needed] I need a formula in cell [TARGET CELL] that calculates: [WHAT YOU WANT]. Give me: 1. The formula 2. A 1-sentence explanation of how it works 3. An alternative approach if there is one 4. Common gotchas to watch for (date formats, exact text matching, blanks)
شاهد الفرق
قبل وبعد استخدام هذا التوجيه
I want to know my total sales for last month from this list. I tried =SUM(C:C) but it adds everything including other months. I tried =SUMIF(B:B,"December",C:C) but it returned 0 even though I have December rows. What's the formula?
Try this: =SUMIFS(C:C, B:B, ">="&DATE(2025,12,1), B:B, "<"&DATE(2026,1,1)) How it works: SUMIFS adds values in column C where column B is on or after Dec 1 2025 AND before Jan 1 2026. Using DATE() functions instead of "December" as text avoids the most common reason your formula returned 0 — your B column is probably actual dates, not text labels, so matching against the string "December" finds nothing. Alternative if you have a real Excel table (Ctrl+T): =SUMIFS(Sales[Amount], Sales[Date], ">="&DATE(2025,12,1), Sales[Date], "<"&DATE(2026,1,1)) Three things that could break it: 1. If your dates are stored as text (look like dates but left-aligned), this returns 0. Fix: use Data → Text to Columns to convert. 2. If column C has any blank cells SUMIFS treats them as 0 — fine. But if it has text like "TBD" mixed in, you'll get #VALUE!. 3. Year boundaries: this formula stops at 2026-01-01. If you copy it to find November next year, change both year arguments. Quick check: =COUNTIFS(B:B, ">="&DATE(2025,12,1), B:B, "<"&DATE(2026,1,1)) should tell you how many December rows exist. If that returns 0 too, your dates are stored as text.
Claude
Excellent at formula generation and the clearest explanations of what each part of a complex formula does. Best when you want to learn, not just copy-paste. Cannot execute formulas to verify them.
افتح Claudeالأسئلة الشائعة
Can ChatGPT write VBA macros for Excel?
Yes, and it does this well. Claude's VBA explanations are slightly clearer, but ChatGPT's are more likely to run on the first try.
Should I just use Microsoft Copilot in Excel instead?
Copilot ($30/user/month) is convenient if you already have an M365 enterprise license, but it can't process AI prompts row-by-row across thousands of rows. ChatGPT/Claude give you more control for one-off complex formulas.
Why does my AI-generated formula sometimes return #N/A or #VALUE!?
Almost always either (1) the date column is stored as text not a date, or (2) text values have invisible spaces. Tell the AI what error you got and paste a sample row — it will fix it.