need help with a formula
So that's what I was doing wrong!! I was thinking that I've seen a way to do
this w/sumproduct and an array constant, but couldn't get it.
Thanks for posting, Ragdyer, that was bugging me.
"Ragdyer" wrote:
Fellas ... You're all forgetting that you're going *across*, not down!
This works fine for me:
=SUMPRODUCT((C12:AG12={"A";"F"})*C13:AG13)
Hit <F9 after selecting "C12:AG12={"A","F"}",
And you see only 2 returns, with the rest being #N/A,
meaning that the formula is polling down.
The semi-colon just tells it to poll across (I THINK)!<g
--
Regards,
RD
---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"T. Valko" wrote in message
...
I can't get the idea SUMPRODUCT(--(C12:AG12,{"A","F"})*C13:AG13)
Don't worry about it. It won't work. It's not syntatically correct for one
thing and even if you correct that, it still won't work.
Biff
"ShaneDevenshire" wrote in
message ...
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
|