Thread: formula help
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
sross002 sross002 is offline
external usenet poster
  
Posts: 29
Default Try this
thanks.

"Gilbert" wrote:

Try the following formula

=SUMIF(D4:G4,"Y",D6:G6)+SUMIF(D5:G5,"Y",D6:G6)

Replace D4:G4 & D5:G5 with your Y and N rows and replace D6:G6 with the
values row.
Reply With QuoteReply With Quote