My Excel formala is not returning the correct value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

This is th formula:
=SUM(IF(Entry_Day_Range=1,IF($H$7:$H$300=GandA_Label,$I$7:$I$300,0),0))
only 1 value in the range fits criteria, but the sum of all values is being
returned.

When I check the formula in the functions window, it shows the correct
results, but the cell does not reflect that.
 
Amazing - why did that work, and how do I know when to use this in the future?

Thanks you very much!!!
 
Lookup array formulas in help


Peo


boothguy said:
Amazing - why did that work, and how do I know when to use this in the
future?

Thanks you very much!!!
Click to expand...
 
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

Scrabble Value calculation for Welsh words 0
Excel formula, sum the value cell and if empty cell left blank 0
How do I sum cells that have values from a text formula? 4
Lookup returning wrong results 0
Complex conditional summing - array COUNT works, array SUM gives#VALUE 4
Sumif on columns with logical answers 1
Excel VBA 1
Add Values that Match 2 Criteria Q 1

Back
Top