SUMIF Formual help

  • Thread starter Thread starter TopSchmo
  • Start date Start date
T

TopSchmo

I have an attendance roster that uses numbers to reflect time spent wit
a student. (e.g. 1=30 min, 2=60 min, etc.) This is reflected in 3
columns denoting the days in the month. I need to total the amoun
spent each month with a student. My question is do I use a combinatio
of SUMIF, nested IFs, or a combination of SUMIF and possibly a VLOOKUP


Thank yo
 
Assume the month is in A2:A32

=SUMPRODUCT(COUNTIF(A2:A32,{1;2}),{30;60})

adapt to fit more requirements

--

Regards,

Peo Sjoblom

(No private emails please, for everyone's
benefit keep the discussion in the newsgroup/forum)
 
Sounds like you just need to total the 31 columns and multiply by 30 minutes

The formula =SUM(A1:AE1)*30/60/24 in a cell formatted as [hh]:mm would show
the total in hours and minutes

Regards

Trevor
 
Back
Top