Google Spreadsheet Post #2499
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI Aug-30-2018
question by: Krish Moeller
https://productforums.google.com/forum/?utm_medium=email&utm_source=best_answer_notification_button#!topic/docs/UuVxTMn1SXY;context-place=forum/docs
COUNTIF the SUM of a Row is Equal to or Larger than 1?
Hello! I am trying to figure out a formula for this, and I feel like this should be easier than I am making it. Any help/expertise would be greatly appreciated. :-)
In short, I am just trying to COUNTIFS all rows for which the SUM of a portion of the row is equal to or larger than 1.
This is what I came up with:
=COUNTIFS('Attendance Report'!A2:A,SUM('Attendance Report'!C:N)>=1)
And this is the sheet I am using: https://docs.google.com/ spreadsheets/d/ 1DSEXf1g0xLYNVd79m_ E0uwEx1jR1fnLHJvQHdgH-DFI/ edit?usp=sharing
Does anyone know what I might be doing wrong?
Thank you so very much!
Best Regards,
Krisha
No comments:
Post a Comment