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
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
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

=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

Related Microsoft Office Questions