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
----
Am I on the wrong track trying to do what I would like, or is thi
possible

--
Message posted from http://www.ExcelForum.com