What Formula?

D

dansargeant

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
 
G

Guest

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Payment calculation 1
Trouble trying to do a 'Count IF' 2
Using =IF(B10<>"",COUNTA($B$10:B10),"") to number rows in columns other than A 2
Finding the position of the i-th non blank cell in a vertical range 6
To combine various cell formulae in to the final cell 1
The opposite of IF function gives #VALUE for value = 0 2
Multiple Arguments - New Twist 2
strange conditional format behavior 5

Top