if or statements

[Guest]

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

 

[Guest]

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

 

[Cutter]

Try this:

=SUMPRODUCT((A1:A10="rain")*(B1:B10="sunny")*(C1:C10={"input","Ful
Reply",""})

 

[Guest]

Thank you this is just what I needed

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