=sumif(a2,"enter text from dropdown",d2:d30)

--
--Chip Smith--
MVP Wannabe :)


"Sue" wrote:

I am trying to write a formula for the following condition

I have three drop downs with values, and if any one of the values from the
drop down is selected, I have sum a column
eg: If A2 OR B2 or C2 then SUM D2:D30

ANy help is appreciated!!