I am having some trouble coming up with the right formula for a project at work.
I have a spreadsheet that is counting individual volunteers and groups and the number of hours in which they serve. Column A is the number of persons serving, B and C are their names and D through I count the number of hours they worked at the particular jobs.
I am trying to total the number of people who perform a certain job and am struggling with the right syntax. Basically what I want to do is if the number in column D is not null, I want to total the number in column A. To count the number of persons, I tried this formula, =IF(COUNTA(D2:D43),SUM(A2:A43)) However, that totals all the persons in column A, not just the ones with values in column D.
Any help you could provide would be appreciated.
Here is a link to the spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0ArVjFVNrzfMUdFRtX3JwVVE1R2h0RFRoSUNnZWMyMmc
Areas in yellow are the cells in question