# SUM with Critera in 3 columns.

#### Chris1987

##### New Member
Hello all. I having been given a spreadsheet that I have been told I can make minimal changes to and i need to get this formula to work if possible? If i cant would i just have to add a new column with the year in?

Which isnt working :/

I have Three Columns with data in, and I only want it to count if if all 3 terms are met. Terms being "2014" in column D, "Jan" in column E and "Y" in column AT.

I apolagise for the bad spelling and gramma.

### Excel Facts

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

#### a massive zebra

##### Board Regular
I think you need consistent row ranges, so either 1 to 1000 or 1 to 5000, but not a mixture of both. If that doesn't work, does this: =SUMPRODUCT(('TASK DETAILS'!D1:D5000="2014")*('TASK DETAILS'!E1:E5000="Jan")*('TASK DETAILS'!AT1:AT5000="Y"))

#### Jonmo1

##### MrExcel MVP
Welcome to the board.

All ranges need to be the same size.

#### a massive zebra

##### Board Regular
If you are using excel 2007 or later, you could just use COUNTIFS: =COUNTIFS('TASK DETAILS'!D1:D5000,2014,'TASK DETAILS'!E1:E5000,"Jan",'TASK DETAILS'!AT1:AT5000,"Y")

Last edited:

#### Chris1987

##### New Member
Thank you so much! I cant believe it was that simple!

#### Jonmo1

##### MrExcel MVP
Glad to help, thanks for the feedback.

Replies
3
Views
215
Replies
5
Views
11K
Replies
1
Views
1K
Replies
0
Views
136
Replies
5
Views
1K