View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
zafar62 zafar62 is offline
external usenet poster
 
Posts: 1
Default countif and sum if if two condition are satisfied

I have the data as under
A B
S 2
S 3
F 4
F 0
M 5
M 6

I want to count no of cells in Column B which has correspoding F in Column A
and value more than 0, like here the result should be one. And can I make
total also by getting the result 4
Please help