View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Kcope8302 Kcope8302 is offline
external usenet poster
 
Posts: 44
Default Ignore Blanks in Countifs statement

I have a single countifs statement that has 3 lists referenced to it.

=COUNTIFS(Data!F$2:Data!F$199,2,Data!E$2:Data!E$19 9,E1,Data!g$2:Data!g$199,F1,Data!h$2:Data!h$199,G1 )

I am trying to have this act as a query system. If one of these list
boxes(Cells E1,F1,G1) is left blank I would like it to be ignored. Therefore
I can have all 3 or a mix of the 3 boxes chosen to see what the difference is
in the data it pulls.

Can someone assist me with this?

Thanks