Hi,
Could you please advice what is my mistake with the below formula:
=SUMPRODUCT(('Completion FC'!$T$136:$T$199)*('Completion FC'!$D$136:$D$199="BORDER"))
I want to count only those value that the D column equal to "BORDER"
Hi,
Could you please advice what is my mistake with the below formula:
=SUMPRODUCT(('Completion FC'!$T$136:$T$199)*('Completion FC'!$D$136:$D$199="BORDER"))
I want to count only those value that the D column equal to "BORDER"
Last edited by sanlen; 12-09-2010 at 10:23 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks