View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Brad Brad is offline
external usenet poster
 
Posts: 846
Default countif with a segmented range

=SUMPRODUCT(--(A3:A8="red"),MOD(ROW(A3:A8),2))

Counts every other row and if it is "red"

--
Wag more, bark less


"Allan" wrote:

Is there an easy way to do a countif with the data in question in every
second column?
The function might look like =countif(A3,C3,E3,"RED")