C
CraigSA
I am trying to set up spreadsheet where I can select a range, by date, from a
couple DTPicker activeX controls, and then sum up some values corresponding
to that date range selected in the DTPicker's from a list of dates from
another spreadsheet. I am struggling at the moment though with the SUMIF
function. As far as I can tell the SUMIF only accepts actual values in the
criteria entry, so I can't even read a value from a cell. I want to say
sumif(*my listed dates*,*my selected date range in DTPicker's*, *range of
corresponding values to sum*) but whenever I try to say, for instance >E12 in
the criteria, it doesn't read cell e12's value, it takes the value as the
letter e. I'm not sure how to read value's from the DTPicker but I haven't
even tried yet because I can't even read in a cell's value.
Please help
couple DTPicker activeX controls, and then sum up some values corresponding
to that date range selected in the DTPicker's from a list of dates from
another spreadsheet. I am struggling at the moment though with the SUMIF
function. As far as I can tell the SUMIF only accepts actual values in the
criteria entry, so I can't even read a value from a cell. I want to say
sumif(*my listed dates*,*my selected date range in DTPicker's*, *range of
corresponding values to sum*) but whenever I try to say, for instance >E12 in
the criteria, it doesn't read cell e12's value, it takes the value as the
letter e. I'm not sure how to read value's from the DTPicker but I haven't
even tried yet because I can't even read in a cell's value.
Please help