count each expences type of sheet 1 and sum to summary sheet 2

[javaidmr]

as per attached sheet, i want to sumup each expences type to each site ID in a summary sheet 2.
please help

[alansidman]

You will need to use the =Sumifs formula. Here is a tutorial on how to use it.

http://office.microsoft.com/en-us/ex...010047504.aspx

[javaidmr]

You will need to use the =Sumifs formula. Here is a tutorial on how to use it.

http://office.microsoft.com/en-us/ex...010047504.aspx

hi
thnakx for the response but my problem could not solve this way.
because i have two criteria
example
"SIDE ID" is repeating in the row, which might be unlimited
"Expenses types" are repeating and according to site ID

so i have two criteria look up the site ID from column B. i am really confused. please can you apply directly in the excel sheet.

[javaidmr]

thanks it works
appreciating your support

[TheExcelphile]

Hi javaidmr!
Welcome to the forum!

Use the following formula in C5 in sheet 2, and copy it across and down.
=SUMPRODUCT(--('sheet 1'!$C$8:$C$32=$B5),--('sheet 1'!$H$8:$H$32=C$4),'sheet 1'!$I$8:$I$32)

Don't forget to click on the little star to the left of this post if you feel I helped

[dilipandey]

hi Javaidmr,

Welcome to the forum.

Try using below formula:-

=SUMIFS('sheet 1'!$I$8:$I$17,'sheet 1'!$C$8:$C$17,'sheet 2'!$B5,'sheet 1'!$H$8:$H$17,'sheet 2'!C$4)

See attached:- sites expences and income report.xlsx

Regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

Cheers

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>

[dilipandey]

Cheers

Suggest you to mark this thread as [SOLVED].. thanks.

Regards,
DILIPandey

<click on below 'star' if this helps>