How JustAnswer Works:
  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.
Ask flopcat98 Your Own Question
flopcat98, Consultant
Category: Microsoft Office
Satisfied Customers: 9108
Experience:  degree in comp sci. 20+ years install work with networks for small and large companies
Type Your Microsoft Office Question Here...
flopcat98 is online now
A new question is answered every 9 seconds

I need a formula to count the number of transactions in a list

This answer was rated:

I need a formula to count the number of transactions in a list that were done this week. i.e count if the date in the column is between last Monday and seven days later.

try this one


you might have to use the datedif function on a different column and then use the count on that column.



Customer: replied 5 years ago.

Thanks thats a step forward but its not quite what I need:

I need to count the number of a certain type of phone call on this log - easy.... Countif(e2:e200,"Call closed")


Hard bit I need to only count them if they happened this week...


How do I include datedif argument in with this?

i think the easiest way to do that is to create a new column of everything that meets the criteria


ie if the date is in A and call closed or not is in B


create a column C Iff(datedif(today,A,7),B,0)

then do countif(c,"closed call")

Customer: replied 5 years ago.

Thanks for the help I managed to get it working using this for your info in future:



Yup than do the count on that column.

Thats great. If i helped you i would greatly apreciate if you gave me a good rating as that is what allows me to be paid

thank you.
flopcat98 and 3 other Microsoft Office Specialists are ready to help you