| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| UDFunctions and nested If-the-else statements | Excel Worksheet Functions | |||
| Linking two IF statements together | Excel Discussion (Misc queries) | |||
| Logical ELSE statements | Excel Discussion (Misc queries) | |||
| Nested IF statements | Excel Worksheet Functions | |||
| If statements | Excel Worksheet Functions | |||
Hybrid Mode
