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

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.
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

S
  • Solved
Use variable to define cell in sumif statement
Replies
3
Views
224
Anthony47
A
L
  • Question Question
SUM except the strikethrough numbers? - NON_VBA
Replies
8
Views
714
_Landon
L
C
  • Question Question
SUMIF being used to compare differences between lists, not working correctly
Replies
1
Views
290
StephenCrump
S
J
  • Solved
3yr Daily CF - Need Cumulative Sum for Each Month (Resetting Monthly)
Replies
3
Views
151
Asbestos_Jen
Asbestos_Jen
G
  • Solved
SUMIFS between two number values
Replies
2
Views
212
geckoman
G

Forum statistics

Threads
1,224,818
Messages
6,181,152
Members
453,021
Latest member
Justyna P

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