| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Calculating if 1 for 2 criteria are true
I am wanting to add c2 to d2 if either a2 or b2 are equal to e1.
I am having a mind blank. How do I do this? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating if 1 for 2 criteria are true
=IF(OR(A2=1,B2=1),Sum(C2:D2),"")
Should do it mate? "The Rook" wrote in message ... I am wanting to add c2 to d2 if either a2 or b2 are equal to e1. I am having a mind blank. How do I do this? |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating if 1 for 2 criteria are true
Hi
=IF(OR(A2=E1,B2=E1),C2+D2,"") -- Regards Roger Govier "The Rook" wrote in message ... I am wanting to add c2 to d2 if either a2 or b2 are equal to e1. I am having a mind blank. How do I do this? |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Calculating if 1 for 2 criteria are true
Try
=IF(OR(A2=E1,B2=E1),C2+D2,"") -- Hope this is helpful Pls click the Yes button below if this post provide answer you have asked Thank You cheers, francis "The Rook" wrote: I am wanting to add c2 to d2 if either a2 or b2 are equal to e1. I am having a mind blank. How do I do this? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Calculating the difference between two dates if two criteria are m | Excel Worksheet Functions | |||
| Calculating the sum if two criteria are met? | Excel Worksheet Functions | |||
| auto set time(now) if criteria=true with no later change | Excel Worksheet Functions | |||
| adding value only if criteria is true | Excel Worksheet Functions | |||
| Countif( 2 criteria = true ?) | Excel Discussion (Misc queries) | |||
![The Rook[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
