Excel tips and tricks

scaeagles · 09-22-2005, 10:01 AM

Well, you just want everything, don't you?

Moonliner · 09-22-2005, 05:15 PM

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.

09-22-2005, 10:01 AM	#1
scaeagles I LIKE! Join Date: Jan 2005 Posts: 7,819	Well, you just want everything, don't you?
	Submit to Quotes

09-22-2005, 05:15 PM	#2
Moonliner 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