One way:
=SUMIF(Program,"Seed",Amount)
In article ,
Carlee wrote:
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,
|