What Formula?
 

Hi,

This one has me stumped. This formula is non-functional but it may
help explain what I want to do. I need to Multiply rows of cells 6:11
by 60 if both cells in the B Column are not blank and adjacent cells
C6:C11 read "Local".

=SUMPRODUCT(--(=COUNTA(B6:B11)),--(E6:E11="Local"))*60

Thanks to anyone who can help.

Dan


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=521167

What Formula?
 

Hi!

Try this:

=SUMPRODUCT(--(B6:B11<""),--(E6:E11="Local"))*60

Biff


"dansargeant"
wrote in message
...

Hi,

This one has me stumped. This formula is non-functional but it may
help explain what I want to do. I need to Multiply rows of cells 6:11
by 60 if both cells in the B Column are not blank and adjacent cells
C6:C11 read "Local".

=SUMPRODUCT(--(=COUNTA(B6:B11)),--(E6:E11="Local"))*60

Thanks to anyone who can help.

Dan


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile:
http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=521167

What Formula?
 

This seems to work:

=SUMPRODUCT(--(B6:B11 < ""),--(E6:E11="Local"),(B6:B11 * 60))

Note: I used your example formula for e6:e11 rather than your description
which said c6:c11.

"dansargeant" wrote:


Hi,

This one has me stumped. This formula is non-functional but it may
help explain what I want to do. I need to Multiply rows of cells 6:11
by 60 if both cells in the B Column are not blank and adjacent cells
C6:C11 read "Local".

=SUMPRODUCT(--(=COUNTA(B6:B11)),--(E6:E11="Local"))*60

Thanks to anyone who can help.

Dan


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=521167

What Formula?
 

Thanks Biff,
You did it again. Works great!
DS


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile: http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=521167

What Formula?
 

You're welcome!

Biff

"dansargeant"
wrote in message
...

Thanks Biff,
You did it again. Works great!
DS


--
dansargeant
------------------------------------------------------------------------
dansargeant's Profile:
http://www.excelforum.com/member.php...o&userid=13852
View this thread: http://www.excelforum.com/showthread...hreadid=521167