need help with a formula
=SUM(SUMIF(C12:AG12,{"A","F"},C13:AG13))
Another one:
=SUMPRODUCT(--(ISNUMBER(MATCH(C12:AG12,{"A","F"},0))),C13:AG13)
Biff
"ShaneDevenshire" wrote in
message ...
Hi Rhonda,
You have a simple formula for one condition already. For the situation of
A
or F you can use:
=SUMPRODUCT(((C12:AG12="A")+(C12:AG12="F"))*C13:AG 13)
Or the more sophisticated:
=SUMPRODUCT(SUMIF(C12:AG12,{"A","F"},C13:AG13))
--
Cheers,
Shane Devenshire
"Rhonda Edwards" wrote:
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
|