Closing balance as on Date

[Haree]

Hi all, I have a stock sheet with 4 columns , Column A = Date, Column B = Particulars (Its Either Sales or Purchase with a data validation ), Column C = Qty , Column D Weight, My first row is opening Balance. I find out my closing stock from Column C using sumifs (C2 + sumifs(C:C,C:C,"Purchase"-sumifs(C:C,C:C,"Sales"). Now i would like to now my closing balance as on a particular date. I am not able to get that using a second criteria for the date column in sum ifs. An help or advice would be very helpfull.

Thanks in Advance

Note: I was initially using sumif i switched to sumifs for this particular date criteria

 

[mamady]

Hi Dear,

Try the following formula (assuming you will put the particular date in cell E1 (replace as per your convenient)
cell E2 =SUMIFS(C:C,B:B,"Purchase",A:A,E1)-SUMIFS(C:C,B:B,"Sales",A:A,E1)

Regards

 

[Haree]

Hey Mamady,
Thank you so much for taking time and helping me i have just changed the formula to "<="&E1 its working fine

 

[mamady]

I'm glad ?