Is the A5 on Sheet1?
Have you tried part-formulas, like
a)=SUMPRODUCT(--('Data from MIS'!M4:M65535=A5))
b)=SUMPRODUCT(--('Data from MIS'!N4:N65535="Not Moderated"))
to see if those parts work?
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"Alex H" wrote in message
...
Hi could some kind eoprson help me please.

Through help from this forum i have arraived at:
=SUMPRODUCT(--('Data from MIS'!M4:M65535=A5),--('Data from
MIS'!N4:N65535="Not Moderated"),'Data from MIS'!P4:P65535)

However this is returning 0 whereas it should be returning 18 from the
data.

What I am trying to do is in Sheet1!C5 add the values in Data from MIS
Column P where Data from MIS!ColumnM is equal to Sheet1! A5 and Data from
MIS!ColumnN is equal to "Not Moderated"

many thanks

A