View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph David Biddulph is offline
external usenet poster
 
Posts: 620
Default need help with a formula

=SUMIF(C12:AG12,"A",C13:AG13)+SUMIF(C12:AG12,"F",C 13:AG13)
=SUMIF(C12:AG12,"T",C13:AG13)
--
David Biddulph

"Rhonda Edwards" wrote in message
...
I need help with a formula. If cells C12 through AG 12 have an "A" or an
"F"
listed in any cell, I want to add and total the actual whole numbers
listed
in cells C13 through AG13 (that have A or F above them in the
column)totaling
them in cell in AH (where I merged the cells 11-13). Then in AI, totaling
all the numbers in C13 through AG13 that have "T" listed in any cell from
C12
through AG 12. And so on. I have tried to figure this out from reading
the
help menu in Excel but I haven't been able to; can someone help.
Thanks,
--
Rhonda

--
Rhonda