Cell value not recognize in an expression

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

Guest

=SUMIF(B21:B24,">=C18",C21:C24
Any reason why the cell value of C18 would not be recognized, if I replace the value of c18 in the expression, it works but putting the value of C18 as a reference in the expression give me zero as an answer.
 
It works, this is 1st time i need to do that with Excel, is this new with 2003? I haven't seen it in any help menu.
Is this always required? If you don't have time to answer it's ok but I am just curious. Wasted my whole afternoon on that one. Thanks on the quick response.
 
Hi!

Not a new thing and has been a "feature" of SUMIF and COUNTIF since
Pontius was a pilot. But I don't pretend to understand why we have to
use this approach.
 

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

Subtotal 3
Sheet Value in Cell? Is this possible 4
Addind cell together with a rest. 5
Getting Info from Last cell used 1
Get Month and Year ONLY from cell value 2
League standings based off final scores 5
Please help!!!!! How do I enter this formula??? 2
Inserting rows and adding to total worksheet 3

Back
Top