Need someone to examine this formula...

  • Thread starter Thread starter soltek
  • Start date Start date
S

soltek

When I use those formulas, I get a 0 result, and I should have at least
100. Where does the "true" factor in? Are the dates cells in th
middle of the formula already the true part of the IF statement
 
oops, didnt read thru entire thread, see that you already had the sumproduct
piece,

try this:
")" is important on where you put it
=SUMPRODUCT((U9:U1002="D")*(L9:L1002>=J6)*(L9:L1002<=L6))*(I9:I1002)
 
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

Excel Need Countifs Formula Help 0
How does this formula work ? 2
Excel VBA 1
IF formula, Partial word, SUM function as result 1
Searching the formula (not the value) for a text string 1
Nested conditional statements 2
Need Countifs Formula Help 3
Multiple Logic in One Formula 0

Back
Top