Notifications
Clear all
General Excel Questions & Answers
3
Posts
3
Users
0
Reactions
88
Views
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
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
{sum(SUMIF(H3:H47*E3:E47,"<10E37"))} Array Formulas
Posted : 13/12/2019 1:36 am