SUMIFS when a column is not blank
![@Diana](https://us.v-cdn.net/6031209/uploads/drupal_profile/files/2019-04/87/1a/n871ac820742e8875bd4353b9ccea0027.jpg)
I have multiple sheets that I am working from where I need to sumifs a column only if another column in the same row is not blank.
This is what I want to do:
If {Column C} is Blank or more than 0, Sumifs {Column B}, if {Column A} is checked
This is what I've tried:
=IF(SUMIFS({Column C}) < 0, "", SUMIFS({Column B}, {Column A}, 1))
Please help
Best Answer
-
Check your formula - you have it set to Column C<0 instead of >.
If I understand correctly it should work with a Sumifs statement:
=SUMIFS(ColumnB:ColumnB, [Column A]:[Column A], 1, [Column C]:[Column C],>0)
You are summing the vaules in Column B if the row in Column A=1 (or checked) and column C is
Vince
Answers
-
Check your formula - you have it set to Column C<0 instead of >.
If I understand correctly it should work with a Sumifs statement:
=SUMIFS(ColumnB:ColumnB, [Column A]:[Column A], 1, [Column C]:[Column C],>0)
You are summing the vaules in Column B if the row in Column A=1 (or checked) and column C is
Vince
-
Thank you! The formula was easier than I was thinking it was going to be.
Help Article Resources
Categories
- All Categories
- 14 Welcome to the Community
- Smartsheet Customer Resources
- 62.1K Get Help
- 348 Global Discussions
- 199 Industry Talk
- 427 Announcements
- 4.4K Ideas & Feature Requests
- 133 Brandfolder
- 127 Just for fun
- 127 Community Job Board
- 455 Show & Tell
- 28 Member Spotlight
- 1 SmartStories
- 282 Events
- 36 Webinars
- 7.3K Forum Archives
Check out the Formula Handbook template!