Excel-13 Add values in array matching specific row labels, column labels within date range

Hi everyone,

I'm having trouble finding a function that will work for what I need. I attached an example of what I'm working with. Basically I need a function that will add values in the array C2:J6 where the row label in column A equals "Client2",the row label in column B equals "REV", and the column header falls between two dates (6/1/14 and 9/30/14 inclusive for this example). The output I'm looking for in this example is 2,216.00.

Any suggestions?? Thanks in advance, I appreciate any help!

example.xlsx

Dan

Hi fadeoutagain27

Welcome to the forum.

You say that you want to add values, so just to be clear, when your conditions are met, do you want the cell value to be 2216 or 520+2216 ?

Will the answer always be this 2,216.00 (which, I suppose, is a nice enough figure) or do you nee the facility to change this figure?

You mention "function"; are you expecting a user defined function, or will a bit of VBA be OK ?

Regards
Alastair

Yes, the dates in the header will always be the last day of the month and the end date of the criteria range will always be too. Also, the headers will always be chronological and each month will only occur once.

Perhaps something like this? That's array formula, you need to press CTRL-SHIFT-ENTER button together, just ENTER alone is not working....

Cheers

Thanks guys, I'll give those both a shot when I get into work. Much appreciated.

Both of these solutions worked for me!! Thanks again, Tony and Azumi, I really appreciate the assistance!