Thread: how do I...
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Guy Cohen[_2_] Guy Cohen[_2_] is offline
external usenet poster
  
Posts: 6
Default how do I...
Hi all
In column A I have numbers
In column B I have two values : "Yes"/"No"
I want C1 to contain SUM(A) but only if B has "Yes"

e,g,

A B C
1 Y 5
2 N
4 Y

TIA
Guy


Reply With QuoteReply With Quote