Hi,
I am unable to get the correct count using the formula :
=SUM(IF(A1:A999="
A",IF(D1:D999="D>d",IF(F1:F999="1",IF(E1:E999="1",1,0)))))
I am trying to get no of records with
" A" values in Column A,
"D>d" values in Column D,
"1" values in Column F,
"1" values in Column E
and Sum all the counts- after applying the nested filters.
Can someone help me in debugging the same?
Will appreciate early response!
Thanks in advance,
Bookmarks