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?
The Formula ive been trying is =SUMPRODUCT(--('TASK DETAILS'!D1:D1000="2014"),--('TASK DETAILS'!E1:E5000="Jan"),--('TASK DETAILS'!AT1:AT1000="Y"))
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.
Your help would be so greatly received.
The Formula ive been trying is =SUMPRODUCT(--('TASK DETAILS'!D1:D1000="2014"),--('TASK DETAILS'!E1:E5000="Jan"),--('TASK DETAILS'!AT1:AT1000="Y"))
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.
Your help would be so greatly received.