Thread: COUNTIF quandry
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JohnLute JohnLute is offline
external usenet poster
 
Posts: 5
Default COUNTIF quandry

I've got this:
=COUNTIF(SWABS!F7:F237,"=*Station 1*")

How can I add =COUNTIF(SWABS!L7:L237,"=*F*")

to this to make it all work? In other words I want to count the number of
"Station 1" values and the number of "F" corresponding values.

THANKS!

--
www.Marzetti.com