If or SUM

[Ellasheba]

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

 

[Jagdev Singh]

Hi Ellasheba

Please find the excel formula attached with the sample file.

Regards,
JD

 

[Jagdev Singh]

Oops missed the attachment. Please review it and let me know if this is what you are looking for.

Regards,
JD

 

[Khalid NGO]

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,

 

[Ellasheba]

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

 

[Ellasheba]

Oops missed the attachment. Please review it and let me know if this is what you are looking for.

Regards,
JD

YES!! YES!! That's it How did you manage it??? I don't even know where to start