sum cell with different criteria

[bongmendoza]

Hi Guys

Am working on our system which need to compute based 3 criteria(2 account titles & date).

I want to have a create separate sheet for the major account Training & Project expense & Office Operation Expense based on the "data entry sheet". Under the major account is the sum of expenses of actual accounts and should be based on date.

Thanks in advance

Bong

[NBVC]

Try:

=SUMIFS('Data entry'!$H:$H,'Data entry'!$C:$C,$A5,'Data entry'!$AI:$AI,TEXT(B$3,"mmm-yy"))

copied down and across