Thank you this is just what I needed

"Duke Carey" wrote:

=sumproduct((A1:A100="rain")*(B1:b100="sunny")*(c1 :c100={"input","full
reply",""}))

"jimar" wrote:

Can anyone assist. I have 4 columns and I want a formula that will sum the
number of times the following condition is met

If Col A = "Rain" and col B = "Sunny" and col C = to either "input", or
"Full Reply" or ""

Thanks