€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides.
|
€uromeinke, FEJ. and Ghoulish Delight RULE!!! NA abides. |
09-22-2005, 05:15 PM
|
#8 |
|
8/30/14 - Disneyland -10k or Bust.
Join Date: Jan 2005
Posts: 9,022
     |
Hummmm....
If we have A B 1 yes 1 2 null 5 3 yes 2 4 null 7 Then try: =SUMPRODUCT((B1:B4)*(A1:A4="yes")) How's that? Note: I just added "null" to help the spacing.
__________________
- Taking it one step at a time.
|
|
Submit to Quotes
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Threaded Mode