View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Ribeye
 
Posts: n/a
Default sumproduct partial text count

Trying to count # of times A occurs with another variable B. i.e.

A-1 1 Trying to find a way to count the # of
A's when they are
A-2 2 greater than 1. I've tried the following
but it doesn't work:
A-3 - =SUMPRODUCT((C33:C453="A*")*(G33:G453)0))
A-4 - It seems like the * is throwing it
off......Help....Thanks
A-5 4
B-1 7
B-2 -