Developing SUMIF formula's over multiple varients

[jimmybangs]

Hi,

A while back I asked about the SUMIF function which was really useful.

I am looking to build on this original formula but neither the SUMIF or SUMIFS formulas are working...here what it is:

<a href="http://www.flickr.com/photos/26865396@N07/6185222707/" title="Example by beckscanvas, on Flickr"><img src="http://farm7.static.flickr.com/6167/6185222707_52d0ddc325.jpg" width="367" height="500" alt="Example"></a>

I am looking to create a formula that will all up the figures based on the criteria within a specific date range - for example by selecting Company A and Workshop in Feb 2011 it will retrun £1678.75

Anybody got any ideas - I've also tried IF functions within SUM functions but can't get it to work.

CHeers,
James

 

[barry houdini]

Hello James, You can use SUMIFS like this:

=SUMIFS(D$2:D$25,A$2:A$25,F2,B$2:B$25,G2,C$2:C$25,">="&H2,C$2:C$25,"<="&EOMONTH(H$2,0))

where F2:H2 contain the criteria, "Company A", "workshop", 1-Feb-2011