Forum

Notifications
Clear all

Need some help ;D, dont know how to fix it

3 Posts
3 Users
0 Reactions
88 Views
(@eithan)
Posts: 5
Active Member
Topic starter
 

Hey, I'm trying to have a formula that would do E3*H3+E4*H4 etc.. but I need it to SUM only numbers, I Wrote that:
=SUMIF(H3:H47*E3:E47,"<10E37") But for some reason I can't find out why it doesn't let me use it :
Does anyone know how to fix it?
Thanks.

 
Posted : 18/11/2019 12:17 pm
(@mynda)
Posts: 4761
Member Admin
 

Hi Eithan,

Welcome to our forum!

I'm not quite clear what you're asking, but I suspect you want to use SUMPROUDUCT:

=SUMPRODUCT(H3:H47,E3:E47)

Mynda

 
Posted : 19/11/2019 4:04 am
(@iptdelhi123gmail-com)
Posts: 1
New Member
 

{sum(SUMIF(H3:H47*E3:E47,"<10E37"))} Array Formulas

 
Posted : 13/12/2019 1:36 am
Share: