Sum based on Countif

[manc]

Good morning Guru's and Demigod's

My brain is mush having not delved into the Excel "Business Side" for quite a while.

We have sheet1, where each row has job number, month job raised, purchase invoices, sales invoices and then profit/loss.

Sheet2 Column A, has a countif to work out the number of jobs raised for each month.

=COUNTIF(Sheet1!$C$1:$C$15650,"Jun-11")

So, if above code is in Sheet2!A1, in Sheet2!A2 I want it to tell me the profit/loss. I can then repeat this code for each month.

The profit/loss amount for each job is in Sheet1!M1


Thanks for your time and anticapted help

Kind Regards
Manc

 

[anandvarma]

can you post some sample data

 

[manc]

http://www.wix.com/stuarteade/example
Please click this link for example of data

Kind Regards
manc

 

[anglais428]

=sumif(date_range,Date_you_want,profit/loss_range)

 

[manc]

Dear anglais428,

Thanks for your time, effort and knowledge.
Mission accomplished.

Kind regards
manc