This is the formula. Thanks for all your help. :)
=SUMIF($C$13:$P$13,"A",$C$14:$P$14)+SUMIF($C$16:$P $16,"A",$C$17:$P$17)+SUMIF($C$19:$P$19,"A",$C$20:$ P$20)
Then B-E respectively.
"Peo Sjoblom" wrote:
=SUMIF(A13:Z13,"A",A14:Z14)
--
Regards,
Peo Sjoblom
"Kat" wrote in message
...
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