If the "Program" column is Column A, and the "Amount" column is Column B,
then try this:
=SUMIF(A:A,"Seed",B:B)
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
"Carlee" wrote in message
...
Hi there,
I am fairly new to Excel. What I want to do is this:
I have a column named 'Program'. I have another column named 'Amount'.
If 'Program' = "Seed" then sum all entries in the 'Amount' column where
Program = "Seed". Can I do this in excel? If so, how?
Kind Regards,
--
Carlee
|