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 ATLPROG Your Own Question

ATLPROG
ATLPROG, Computer Software Engineer
Category: Programming
Satisfied Customers: 7677
Experience:  MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
44910485
Type Your Programming Question Here...
ATLPROG is online now
A new question is answered every 9 seconds

I need to sum the number of events in a series that have

Customer Question

Hi I need to sum the number of events in a series that have an "x" value and andd them up by month..
Submitted: 6 months ago.
Category: Programming
Customer: replied 6 months ago.
Trying to add the number of events with "X" condition (it is a number, "4" or "8") and then add them up by month for a couple of years, so need to distinguish between May 2015 and May 2016.
My phone number is(###) ###-####
Customer: replied 6 months ago.
Please see document attached. I need to fill out columns J and K (in yellow). With the number of events with condition "4" and "8"
Customer: replied 6 months ago.
Cannot use pivot table, must be through formula please
Expert:  Ingo U replied 6 months ago.
Hi, I will review your question.If needed, would a solution involving a VBA macro be acceptable ? (note - this is not an option on Mac platform)Thanks,Ingo U