Hi all,
I'm trying to use COUNTIF and SUMIF to count and sum values across an array that are greater than a specific value. My formula looks something like: =SUMIF(A2:H230,">B1"). The issue is that it returns zero. If I reference the value in B1 (i.e. ">104.7"), instead of the cell, it returns the numbers I'm looking for. I have the same issue with the COUNTIF function. All cells are formatted as numbers. Is there anyway to reference the cell in the conditional, instead of having to hard code it's value?
Thanks for any help!
Bookmarks