Sumproduct If Q

J

John

I am trying to multiple columns J x I if Column J = 0.135. I've used the
following but I'm getting a #Value! error - any ideas

Thanks



=SUMPRODUCT(--(J16:J28=0.135),(I16:I28,J16:J28))
 

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

SUMPRODUCT 3
If Statement inside If statement.... 3
VBA set thick borders around non empty cells in range 0
Sumproduct Q 4
if or formula 4
String to Rounded Integer 3
Formula Referencing Columns By Date 2
Calculate time difference between cells 3

Top