• 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

E

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

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,
 
Khalid NGO said:
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,
Click to expand...
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 !!
 
You must log in or register to reply here.
Back
Top