View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
silk723 silk723 is offline
external usenet poster
 
Posts: 4
Default Need two different data types to give me a total

I'm not an Excel expert, but I'm pretty sure there's a formula for what I
need to obtain a total.

I need to determine what my total (count?) would be if d2:d30="x" and
g2:g30=not blank.

Can anyone help me determine the formula to get this total?

Thanks in advance.

--
twc