SUMPRODUCT/COUNTIF
Are all the column sizes the same i.e 2 to 9999?
"luvthavodka" wrote:
I am currently using the following formula to count the number of times an
item is in column "Complete_Date_May" is blank, when there is a date in
"Post_Date_May" greater than 27 days old.
=SUMPRODUCT(--(Post_Date_May<""),--(Post_Date_May<TODAY()-27),--(Complete_Date_May=""))
This gives a total figure of outstanding post. I now wish to add that the
corresponding name in column F must equal "Becky". I have tried the following:
=SUMPRODUCT(--(Post_Date_May<""),--(Post_Date_May<TODAY()-27),--(Complete_Date_May=""),--($F2:$F9999=$J2))
Where J2 currently shows the name Becky. This however is returning #VALUE.
How can I add this extra variable to my original formula?
|