Well I see I started something with the {"F","A"}.

Of course =SUM(SUMIF(C12:AG12,{"A","F"},C13:AG13)) and
=SUMPRODUCT(SUMIF(C12:AG12,{"A","F"},C13:AG13)) are identical.

However, I can't get the idea SUMPRODUCT(--(C12:AG12,{"A","F"})*C13:AG13)
to work and I'm not sure I follow the logic?

--
Thanks,
Shane Devenshire


"Teethless mama" wrote:

Try this:

SUMPRODUCT(--(C12:AG12,{"A","F"})*C13:AG13)


"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