Help : Combining Sum If & Vlookup

Dear All,

need help in calculation as examples attached.

in the attachment there are 2 sheet that contain

1. Budget ( contains a list of info such as peoples budget, peoples grade, and product/ expense code)
2. Expense (contains a list of actual budget for every person in a month)

i was trying to find out :
1. actual expenses of every people a month, is it over budget or not
2. remaining budget for every each one
3. Forecast ing an expensed for a months to come

i was trying to calculating it using sumif dan vlookup buat its always turn out Null/zero in results.


hope anyone here can help me,


thx in advance

Maybe something like this.....?

Originally Posted by azumi

Maybe something like this.....?

wow, ...
thk u for the help and fast response.

i thought u would use sum if/ if + Vlookup.
is "sum product alot easier / simple in use?
or is it better to use ?

Im use SUMPRODUCT because its efficient handle an array ranges without CTRL-SHIFT-ENTER stuff..... and memory friendly...

Cheers bro....

ente dmn gan, kursus gan.......

salah gan, ane itung manual aja total biaya yg dikeluarin boy selama sebulan cm 48000.