sumif multiple columns

[Mr2017]

Hi

I'd like to create a sumif formula that sums up data based on criteria in multiple columns, but not sure if this is possible?

In the table below, I'd like to sum up the number of HOURS for Greg (a user) that are

i) approved (column G)
ii) billable (column H)
iii) from the month of August (column I)
iv) from the 16/17 financial year

Then answer should be 2 (because the 5 hours in column F are non-billable - see column H). So 1 hour from the 4th of March and 1 hour from the 5th of March would be summed up to give the value 2, because those hours fulfill all the above criteria.

Is that possible? A basic part of the results would like like the second table below. Thanks in advance!

A	B	C	D	E	F	G	H	I	J
Client	Project	Work Item	User	Date	Hours	State	Billable?	Month Name	FY
X	X Calibur	Checks	Greg	03-Mar-16	5		Non-Billable	Mar
X	X Calibur	Checks	Greg	04-Mar-16	1	Approved	Billable	Mar	16/17
X	X Calibur	Checks	Greg	05-Mar-16	1	Approved	Billable	Mar	16/17

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>

Second table

	2016
	Month
User	March	April
Greg	Sum of approved hours in March 2016
	Value should be 2 (1 hour on 4th & 1 hour on 5th March)

<colgroup><col><col><col></colgroup><tbody>
</tbody>

 

[SpillerBD]

If you have Excel 2007 or later, you should be looking at SUMIFS

SUMIFS function - Office Support

 

[tcardwell]

Kinda like:
=SUMIFS(Hours,State,"Approved",Billable?,"Billable",Month_Name,"Mar",FY,"16/17")
Named ranges were created from your column headers to make formula more readable.

 

[Mr2017]

Thanks Spiller BD - that was the most useful article I read on sumifs - explained things clearly!

Thanks again.

 

[Mr2017]

Thanks tcardwell - yes, I used that format with named ranges to construct the formula. Previous articles I'd read weren't helpful, but I was able to compile what you described after reading the article Spiller BD posted. Thank you both.