Sumproduct

P

Probyn

I am trying to sum a range, column "C" on the condition that the value
in column "B" >= 3000 and <4000. The formula I am using is
=SUMPRODUCT((A1:A9>3000)8(A1:A9<4000 ),(C1:C9)). When some playing
around I either get the sum of the entire column or 0. Neither answer
is correct. Appreciate your help.
 
D

Dave Peterson

Your formula is looking at column A.

It's better to copy and paste directly from excel into the newsgroup post. If
you just type it into the newsgroup message, it's difficult to guess if it's a
real problem or just a typo in the post (like 8 instead of *).
 

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

Formatting and copy or copy and formatting ?? 2
Reference a row programmatically 1
Group By Calculations and Labeling 2
Sumproduct formula needed 2
Vlookup error 1
Code not working 3
Insert columns and values programmatically with IF statement 9
Move data from first 7 rows from one column A into multiple Columnsthen the next 7 rows 2

Top