Thread: SUMProduct help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jeremy Jeremy is offline
external usenet poster
 
Posts: 85
Default SUMProduct help

=SUMPRODUCT(($D$2:$D$23=$A28)*($C$2:$C$23=10)*($e $2:$e$23,NONBLANK))

I knoe the first 2 legs of the formula work, i am already using them. all i
want to add in the new call is another criteria: that being when e2:e23 are
not blank.

What do I put where NONBLANK is in my formula?