Total in specific circumstances

[mantona]

I have a problem with my Excel sheet. (I can email sheet if you like, can't manage to understand the image posting thing on here, sorry).

My company lends out work tools to different section of the company itself. I am developing a way of tracking this data and need help please.

I have described in more detail below:
1ST EXCEL SHEET TAB - Lending of equipment as it happens logged to this sheet. {MAINDATA TAB}

Each section lends out equipment (Column A). This will contain data as it happens e.g. if 'section 1' gets lent work tools for x amount of hours 'Column C', for reason ( 'Column B'. There are 10 sections in total that may or may not use equipment.

Reasons can be from 1 - 6 (Column B). Numbers represent real reasons e.g. lost equipment = 1.

(Column C) represent the amount of hours lending takes place.

(Columns D - I) represent total hours [IF B2 = 1 then place in the hours in the correct column], gives me total for each reason per month.


2ND EXCEL SHEET TAB
'Sections' as above listed across top row.


total of hours per area, and totals per reason listed down the first column. these are the formulae which I am having difficulty with.


Hoping this makes sense. I can post my sheet to you, or if you can explain ho I can put a sheet online then that would be great.


Thank you very much for any help in advance.

 

[AlphaFrog]

What version of Excel do you have?

You want to Count or Sum based on more than one criteria...

If you have Excel 2007 or later, use the SUMIFS or COUNTIFS functions.

If you have Excel 2003 or earlier, use the SUMPRODUCT function.

 

[mantona]

Thank you for your help. I tried sumifs and it worked!

I have Excel 2007.

Is there a difference in the way that sumifs and countifs work?

Thanks again

 

[T. Valko]

Thank you for your help. I tried sumifs and it worked!

I have Excel 2007.

Is there a difference in the way that sumifs and countifs work?

Thanks again

SUMIFS is for a multi conditional sum
COUNTIFS is for a multi conditional count

The syntax and criteria expressions are similar for both functions.

Is there some specific difference you want to know about?