# SUMIFS using multiple columns

1. ## SUMIFS using multiple columns

Hello guys,
hope you can help me with this SUMIFS:

I am creating a chart to show the daily usage in minutes for a certain condition.
So SUMIFS must verify IF in the row contains my text condition, and if yes, sum the minutes based on that specific day.

The problem here is that I have multiples dates in different columns, so SUMIFS is not working properly.

My formula: =SUMIFS(B2:B10,A2:A10,"*Red*",C2:M10,C13)

I am sure this must be easy for you guys :)

2. ## Re: SUMIFS using multiple columns

Welcome to the forum.

You can't use 2D arrays with SUMIFS. Try this:

=SUMPRODUCT((A2:A10="*Red*")*(C2:M10=C13)*(B2:B10))

3. ## Re: SUMIFS using multiple columns

Originally Posted by AliGW
You can't use 2D arrays with SUMIFS.
You can, provided all arrays referenced are of an equal dimension (i.e. all are 2D).

Regards

Interesting!

5. ## Re: SUMIFS using multiple columns

Thank you, that worked for me

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1