I have a Sumproduct function that seems to work perfectly well, as long as the main data range doesn't have any letters or "" in.
this is an example of the function
=SUMPRODUCT(($A$1:$A$896=AD882)*($B$1:$B$896="CFT")*($C$1:$AA$1>($AD$880-7))*($C$1:$AA$1<=$AD$880)*($C$2:$AB$896))
where $AD$880 is a date, I'm trying to get a sum of the data for a week at a time.
How can I get it to ignore any letters or "" that are in the range of $C$2:$AB$896?
thanks
Bookmarks