K
KevinK9
I am trying to create a conditional sum, but cannot figure out how to d
it for my case. I will post a few rows from my sheet first.
01/09/04 01/11/04 1 1 50.00% 0
02/19/04 02/21/04 1 1 1 75.00% 1
11/19/04 11/21/04 1 1 1 1 1 125.00% 1
Meeting Attendance % 100.00% 150.00% 100.00% 50.00% 100.00% 0.00%
of Meetings 2
The first two columns are the dates. The next six columns ar
different people. A one in their column would indicate they attende
that meeting. Next column is a total attendance percentage, with
people counting as 100%. The final column is a 1 if cell to the lef
is >74%, otherwise 0.
My conditional sum is:
If attendance is 1, and last column is 0, do not add to sum.
If attendance is 1, and last column is 1, add to sum.
(Then I have to divide that sum by the the # of meetings value for m
percentage)
I am hoping to correct my Meeting Attendance formula.
Corrected, the percentages should be:
Meeting Attendance % 100.00% 100.00% 100.00% 50.00% 50.00% 0.00% # o
Meetings 2
it for my case. I will post a few rows from my sheet first.
01/09/04 01/11/04 1 1 50.00% 0
02/19/04 02/21/04 1 1 1 75.00% 1
11/19/04 11/21/04 1 1 1 1 1 125.00% 1
Meeting Attendance % 100.00% 150.00% 100.00% 50.00% 100.00% 0.00%
of Meetings 2
The first two columns are the dates. The next six columns ar
different people. A one in their column would indicate they attende
that meeting. Next column is a total attendance percentage, with
people counting as 100%. The final column is a 1 if cell to the lef
is >74%, otherwise 0.
My conditional sum is:
If attendance is 1, and last column is 0, do not add to sum.
If attendance is 1, and last column is 1, add to sum.
(Then I have to divide that sum by the the # of meetings value for m
percentage)
I am hoping to correct my Meeting Attendance formula.
Corrected, the percentages should be:
Meeting Attendance % 100.00% 100.00% 100.00% 50.00% 50.00% 0.00% # o
Meetings 2