Thread: Help :O(
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Toppers Toppers is offline
external usenet poster
 
Posts: 4,339
Default Help :O(

Try:

=SUMPRODUCT(--(IF(MOD(COLUMN(A1:F1),2)=1,1)),--(A1:F1="P"))

entered with Ctrl+shift+enter

"Juan S." wrote:

If I have for example, A1=P, B1=F, C1=P, D1=P, E1=P and F1=F..... what
formula do I use to just count "P" for ONLY (A1, C1, E1)?

I'm looking for a formula that would only count specific cells.

Thanks,