Hi everyone,
This is driving me mad and no doubt an easy fix.
I have a spreadsheet where column A has numerous values, and column B has date values. I have, on another sheet, a date.
My formula looks in the range A1-A100 and i have two entries in rows 5 and 6 with dates within a 30 day range.
Its for monthly reporting of calls based on the customer who calls in.
However the following formula isn't returning the 2 that it should be and is only returning 1. It works perfectly well on every other customer name (customer2), just not this one.
=COUNTIFS('Sheet1'! $A$1:$A$100 , "*Customer1*" , 'Sheet1'! $B$1:$B$100 , ">=" & 'Sheet2'!$A$1 , "<=" &'Sheet2'!$A$1 )
Thanks for any advice
This is driving me mad and no doubt an easy fix.
I have a spreadsheet where column A has numerous values, and column B has date values. I have, on another sheet, a date.
My formula looks in the range A1-A100 and i have two entries in rows 5 and 6 with dates within a 30 day range.
Its for monthly reporting of calls based on the customer who calls in.
However the following formula isn't returning the 2 that it should be and is only returning 1. It works perfectly well on every other customer name (customer2), just not this one.
=COUNTIFS('Sheet1'! $A$1:$A$100 , "*Customer1*" , 'Sheet1'! $B$1:$B$100 , ">=" & 'Sheet2'!$A$1 , "<=" &'Sheet2'!$A$1 )
Thanks for any advice