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    Mar 18, 2013
user NDHS :(!category-topic/docs/spreadsheets/t6ciYC9bTyE)

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