Is it possible to use SUMIFs vertically and horizontally?

[DashboardNovice]

I have the following SUMIFS formula:

=SUMIFS('Overall Depreciation Schedule'!$M6:$DP6,'Overall Depreciation Schedule'!$E:$E,E6,'Overall Depreciation Schedule'!M$5:DP$5,"<="&DATE(B2,12,31))

The sum range is horizontal. Criteria range 1 is a column of numbers. Criteria range 2 is a row of dates.

The problem might be in the 2nd criteria with the DATE function.

Is it possible to have a vertical and horizontal criteria range in the same SUMIFS formula?

If so, what am I doing wrong?

 

[NARAYANK991]

Hi ,

No. In all of the SUMIF family of functions , all ranges have to have the same orientation , and be of the same size.

Narayan

 

[Bhawani]

As of i know Sum Range & Criteria Range should be match
also it should be either Vertically or Horizontally.



Regards,

 

[Hui]

You can always try a Transpose() function around the odd criteria or ranges

This is more likely to be possible in Sumproduct() that Sumifs()

Can you post a sample file ?

 

[NARAYANK991]

Hi ,

It is not the criteria which are the ranges in your posted formula ; it is the data ranges which are a column in one case and a row in the other.

Narayan