Sumif across columns

Originally Posted by 63falcondude

If you change the text values in row 9 to actual dates (which can be formatted however you'd like), then you should be able to work with your data.

For example, change all of row 9 from Text formatting to General. Then change Z9 to 7/1/2017 and you can format as custom mmm yyy.

Yeah, but how do I sum the data for 2016 fiscal year based on the month criteria in column AZ?

I have done it manually by adding "sum" function, however I am wondering if there is a way to use a formula?

This will eliminate any errors in case I miss a certain month.

let me know - i have attached the file again.

thanks

I noticed that the date in AZ8 is 6/16/2017 (displayed as "16-Jun"). Is that supposed to be Jun 2016 (i.e. 6/1/2016)?

If so, you can try something like this:
=SUMPRODUCT((Z10:AW4848)*(Z9:AW9>=AZ7)*(Z9:AW9<=AZ8))

Keep in mind that this will only work after you make the changes mentioned in post #2.

I would use a DSUM rather than a sumif or sum product. Set up a separate criteria range by copying your headings, highlight all the data including headings and all the criteria entered under the headings on the criteria range including the headings again. the formula is straight forward =DSUM(database, FIELD which is column number, then criteria.

great secret formula that not many know about.

I tried dsum but not sure what I am doing incorrect?

thoughts? see attached workbook

any thoughts on this guys?