Criteria in sum if ?
I want to reference another cell in the criteria for sumif - look at the
example below - can this be done ?
=SUMIF(B1:B10,"<C1",A:A10)
In the criteria section if I have an argument like "<1,000", for eg., it
works, but if I refer it to another cell it doesn't work. Do you have any
suggestions ?
Thanks,
Shailesh Muzumdar
|