• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

If or SUM

Ellasheba

Member
Can someone help please? I am trying to get the correct formula to compare a set of months by another set of months. I have tried SUM and IF but must be doing something wrong as it wont work :-( I have attached an Excel sheet with some dummy data to demonstrate). I dont use VBA but want to keep updating this data each month....

many thanks in advance
 

Attachments

  • Test formula.xlsx
    9.5 KB · Views: 0
Oops missed the attachment. Please review it and let me know if this is what you are looking for.

Regards,
JD
 

Attachments

  • Test_formula(1).xlsx
    10 KB · Views: 1
Hi Ellasheba,

Not understood your question.
Please describe in some details, what do you mean by:
"compare a set of months by another set of months"

Regards,
 
Hi Ellasheba,

Not understood your question.
Please describe in some details, what do you mean by:
"compare a set of months by another set of months"

Regards,
Hi ... I want to look over 6 months comparing the first 4 months to most recent 2... The aim is to highlight where there have been 0 sum in the first 4 months But anything over 0 in the following 2 months maybe using the phrase Yes for the true result !!
 
Back
Top