Sumproduct If Q

  • Thread starter Thread starter John
  • Start date Start date
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))
 
Hi John

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

cheers
JulieD
 
You must log in or register to reply here.

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

Counting Blank Cells 5
SUMPRODUCT 3
If Statement inside If statement.... 3
VBA set thick borders around non empty cells in range 0
Sumproduct Q 4
Change Range In COUNTIF Formula Based On Value In A Cell 1
if or formula 4
String to Rounded Integer 3

Back
Top