= sumifs ?

[zone709]

Hi so I am using this below and it works fine. I need update it in a way if I can to sum columns G to K same range if 50 Hud is present

=(SUMIFS($G$2:$G$200,$A$2:$A$200,"50 Hud")) <-- this works


This is what I tried to do and it returns #Value

=(SUMIFS($G$2:$​

K​

$200,$A$2:$A$200,"50 Hud"))

I change the G to K so it can pick up all those columns but cant get it. Rather then doing + sumifs + sumifs would like to stay away from that if possible.​

 

[Marcelo Branco]

Maybe...

=SUMPRODUCT((A2:A200="50 Hud")*G2:K200)

or this array formula (more robust)
=SUM(IF(A2:A200="50 Hud",G2:K200))
Ctrl+Shift+Enter

M.

 

[zone709]

Hi thnaks for the reply.

=SUMPRODUCT((A2:A200="50 Hud")*G2:K200) This still returns Value right.



=SUM(IF(A2:A200="50 Hud",G2:K200)) This is working but gives me all the value from those columns G to K Even if there is not "50 Hud" In column A I have like

"50 Hud"

"50 Hud2"

"50 Hud3" ​

Just looking for the Sum from

"50 Hud". It returns all sums​

_{^{<strike>
</strike>}}​

​

​

<strike></strike><strike></strike>

 

[zone709]

Hi forget it the last one works. I forgot to use

Ctrl+Shift+Enter Sorry about that thanks for the help again​

 

[Marcelo Branco]

Hi forget it the last one works. I forgot to use

Ctrl+Shift+Enter Sorry about that thanks for the help again​

You're welcome. Glad to help.

M.