Assuming I understand.
Cell A13, drop down menu for meeting type that you want a tally of total
hours for meetings.
Cell A14, is total time of meetings (0.25 - 10 each).

You have 3 sections that have a meeting type (rows 13, 16, & 20, columns C-P)
and the time frame for each meeting is entered just below.

This should work, if my assumptions are correct.
A14:
=SUMIF(C13:P13,A13,C14:P14)+SUMIF(C16:P16,A13,C17: P17)+SUMIF(C20:P20,A13,C21:P21)
--
John C


"Kat" wrote:

C13:P13+C16:P16+C20:P20 for A-E
C14:P14+C17:P17+C21:P21 for .25-10


"John C" wrote:

Well, if I select A in A13, and .25 in cell A14, then the total is just .25.
What is the range of cells that will have A through E, and what is the range
of the cells that will have the corresponding lenght of time?
--
John C


"Kat" wrote:

A = Annual Meeting
B = BOD Meeting
C = Contractor Meeting

Then the numerical value in the drop down menu below equals the amount of
time spent at the meeting.



"John C" wrote:

In A13, what values do A through E represent?
--
John C


"Kat" wrote:

The value needs to be 0, itself or added to any other cell that used A - E
respectively during the month. And no each numeric value is chosen based on
the amount of time spent on a given day.

Kat



"M Kan" wrote:

What are you adding the numeric value too and do the numeric values
necessarily corresponded to the same alpha values all the time?
--
Tips for Excel, Word, PowerPoint and Other Applications
http://www.kan.org/tips


"Kat" wrote:

On a calendar I have two drop down menus - the first has an alphabetic value
(A13)A - E respectively, the second drop down below it (A14) has numeric
values .25 - 10. How do I make it add the numeric value per alphabetic
value?


Thanks - Kat