if or statements
 

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

if or statements
 

=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

if or statements
 

Try this:

=SUMPRODUCT((A1:A10="rain")*(B1:B10="sunny")*(C1:C 10={"input","Full
Reply",""}))


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=527561

if or statements
 

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