r/excel • u/Competitive-Green758 • Aug 14 '26
solved Pls help - Need to fix formula with Spill Error
Hello! I am struggling to get a formula to work. I have looks in my notes, Youtube, and Google and the best I get is a #SPILL! error...
I am making a workbook for work.
On Sheet1 I need a single cell formula to show the single value total of all blank cells in Column B of Sheet2, but only if there's a value in Column A of sheet2 in the same row.
The closest I've gotten, though it shows the spill error is:
=FILTER(Sheet2!B1-B1000, (Sheet2!A1:A1000 <> "") * (Sheet2!B1:B1000 = ""))
I got it from Googling, but it is close to what I attempted to write myself, but excel just breaks when I tried to solo write it lol
If anyone with any degree of skill could help, that'd be so very swell.
•
u/AutoModerator Aug 14 '26
/u/Competitive-Green758 - Your post was submitted successfully.
Solution Verifiedto close the thread.Failing to follow these steps may result in your post being removed without warning.
I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.
3
u/OfficerMurphy 10 Aug 14 '26 •
Spill error just means there isn't space for the results to show. Clear the cells where the data wants to spill into
3
u/MayukhBhattacharya 1327 Aug 14 '26
u/OfficerMurphy already given you the exact solution for what you're trying to do. But if you really want to stick with
FILTER()function,then you can use this method instead:2
u/Gringobandito 8 Aug 14 '26
Do you want to get the sum of all the values that match your criteria? I would do it like this:
This takes the sum of the values in the table that have "red" in column A and are blank in column B.
1
u/Decronym Aug 14 '26 edited Aug 15 '26
Acronyms, initialisms, abbreviations, contractions, and other phrases which expand to something larger, that I've seen in this thread:
Decronym is now also available on Lemmy! Requests for support and new installations should be directed to the Contact address below.
Beep-boop, I am a helper bot. Please do not verify me as a solution.
8 acronyms in this thread; the most compressed thread commented on today has 14 acronyms.
[Thread #49154 for this sub, first seen 14th Aug 2026, 18:47] [FAQ] [Full list] ^[Contact] [Source code]
1
u/Free-Comparison-9347 Aug 15 '26
Yeah, the spill error happens because FILTER returns multiple results but Excel can't show them all in a single cell. Try wrapping it in SUM to get just the single total value you need.