Thursday, August 30, 2018

yogi_Row By Row Count Of Entries In Columns C2 Through N18 >=1

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)


Does anyone know what I might be doing wrong?

Thank you so very much!
Best Regards,
Krisha

No comments:

Post a Comment