Date Formulas

  • Hi,

    If i have a list of Quotes each with an estimator attributed to them and a date of submission, what formaula can i use to calculate the amount of quotes an estimator has done in august 2004 for instance.

  • If your quotes are in col a estimator in b, and date in col c, then:
    =SUMPRODUCT((MONTH(C5:C10)=8)*(B5:C10="Bill")) will count all of the estimates Bill did in August. If you want to total the estimates then:

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!