Sumifs

K

kmbrly

New Member
Joined
Nov 28, 2018
Messages
4
I am interested in using Sumifs function on blank criterion. i.e. =SUMIFS(F10:F66,D10:D66,"MANUAL ADJUSTMENT (SET)"+SUMIFS(F10:F66,D10:D66,"BLANK CELL")). Thank you in advance
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
Sort by date Sort by votes
If you want to test for blanks, just use back to back quotations with nothing between them.

Change
"BLANK CELL"
To
""
 
Upvote 0
The formula you posted won't work, maybe

=SUMIFS(F10:F66,D10:D66,"MANUAL ADJUSTMENT (SET)")+SUMIFS(F10:F66,D10:D66,"")
 
Upvote 0
You must log in or register to reply here.

Similar threads

A
  • Question Question
sumifs not blank
Replies
1
Views
66
Alex Blakenburg
A
S
  • Solved
Use variable to define cell in sumif statement
Replies
3
Views
249
Anthony47
A
L
  • Question Question
SUM except the strikethrough numbers? - NON_VBA
Replies
8
Views
766
_Landon
L
N
  • Solved
SUMIFS with numbers as criteria and wildcard
2
Replies
10
Views
195
norts55
N
C
  • Question Question
SUMIF being used to compare differences between lists, not working correctly
Replies
1
Views
304
StephenCrump
S

Forum statistics

Threads
1,225,737
Messages
6,186,722
Members
453,369
Latest member
positivemind

Share this page

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top