• Ask an Expert
• Get a Professional Answer
• 100% Satisfaction Guarantee
flopcat98, Consultant
Category: Microsoft Office
Satisfied Customers: 8959
Experience:  degree in comp sci. 20+ years install work with networks for small and large companies
23372949
Type Your Microsoft Office Question Here...
flopcat98 is online now

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

=countif(range,datedif(startdate,endate,differnce))

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

Customer: replied 4 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 4 years ago.

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

=IF(DATEDIF(C2,TODAY(),"d")<7,E2,0)

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 6 other Microsoft Office Specialists are ready to help you