Monday, March 18, 2013

yogi_Tally The Number Of Hours By Name And TypeOfWork


                                          Google Spreadsheet   Post  #1086
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.    Mar 18, 2013
user NDHS :(http://productforums.google.com/forum/?zx=9bydteme3h15#!category-topic/docs/spreadsheets/t6ciYC9bTyE)
Hi, 

How do I adapt the countif formula to look at two criteria instead of just one? Or is it a completely different formula? 

Here is the ss - top sheet is raw data. "tally" sheet looks at the raw data for name and type of hours and returns the total on the tally sheet. 

Thanks so much. 
-----------------------------------------------------------------------------------------------------------------------------
following is a solution to the problem