if or statements

J

jimar

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
 
D

Duke Carey

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

Cutter

Try this:

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