I have 2 columns of data
column A contains dates in the format mmm/yy
column B contains monetary amounts ie £300.67
I want to sum the figures in column B if the entry in column A is equal to or between two values in F! and G1
How do I get sumproduct to do this ?
column A contains dates in the format mmm/yy
column B contains monetary amounts ie £300.67
I want to sum the figures in column B if the entry in column A is equal to or between two values in F! and G1
How do I get sumproduct to do this ?