Friday, May 25, 2018

yogi_Array Formula For Sum Of Hours By Student And Date For Entries In Separate Date Sheets

Google Spreadsheet   Post  #2452

Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     May-25-2018

question by: JP1128
https://productforums.google.com/forum/?utm_medium=email&utm_source=ba_notification#!topic/docs/IHm7O4C7X_k;context-place=forum/docs

SUMIFS in ArrayFormula?

https://docs.google.com/spreadsheets/d/1E5IJET7tgSw3zrgYuDJGMWnMknEytX1jknuphHXKfxU/edit?usp=sharing
Working on Students!

I'm having a problem with the Column D. I need to make it so that when the person's Attend becomes "Y" the sum of the person's hours in the 8/10! would be calculated and returned.

I tried this
=ArrayFormula(SUMIFS('8/10'!$I2:$I,'8/10'!$E2:$E,$A3:$A))