Adding totals for 2 line with Sumif

Right now I have a column and the formula looks like this.

=SUMIF('Running Totals'!N:N,'Inventory Sheet'!B3,'Running Totals'!E:E)

It works great and gives me the totals from E:E with the correct corresponding inventory names. How do I get this formula to add some other number from another column. Such as....

=SUMIF('Running Totals'!N:N,'Inventory Sheet'!B3,'Running Totals'!E:E) + ('Running Totals'!N:N,'Inventory Sheet'!B3,'Running Totals'!F:F)??

Essentially I am wanting to add E:E lines and F:F lines together to get one sum with the corresponding inventory ID.

hi Aussie1, maybe this
=SUMPRODUCT(('Running Totals'!N1:N1000='Inventory Sheet'!B3)*('Running Totals'!E1:E1000+'Running Totals'!F1:F1000))

adjust range accordingly.

Originally Posted by Aussie1

Tried it. Not working.

Can you elaborate a little on what exactly isn't working? Are you getting an error message, or an incorrect sum, or......?

Incidentally, you weren't too far off with your original formula, apart from A) the lack of a 2nd SUMIF, and B) your "+" was surrounded by spaces.

Please Login or Register  to view this content.

in E3 on your Inventory tab seems to work - it's returning 11.

Hope this helps.

like Brendan mentioned, do state how it doesn't work for you. "Tried it. Not working." doesn't help us a lot. i'm assuming you need to find the text from B3 in "Inventory Received" & then go to column N in "Running Totals" to see if there's a text "F308P". if it does, sum up column E & F. if so, change my formula slightly so that it excludes the header & starts from row 2:
=SUMPRODUCT(('Running Totals'!N2:N1000='Inventory Sheet'!B3)*('Running Totals'!E2:E1000+'Running Totals'!F2:F1000))

You're welcome. Thanks for the rep.

You should also consider trying benishiryo's amended formula - it may be more efficient (quicker/require less resources) with large amounts of data.