countifs too many digits

  1. G

    Countifs formula return wrong values

    Hi, I am using the Countifs function to count the number of times a customer (using their account number in the formula) has made a transaction in any given week. My formula looks like this (for purchases): =COUNTIFS('15-Aug-2010'!$C$3:$C$9072,'SMS...

Some videos you may like

This Week's Hot Topics