Report

SUM IFS function [Solved]

Ask a question dshaviv 2Posts Sunday September 24, 2017Registration date September 25, 2017 Last seen - Last answered on Sep 25, 2017 at 01:22 AM by dshaviv
Hello,

I need a formula to sum the values in a range of cells if the content in another range of cells equals the text currently in a cell in a completely separate table.

For example,

sum the values for D7:D999
If the text in G7:G999 equals the text in 'sheet2'!B9 (a completely different cell in another sheet)

Note: The text in cell B9 changes which is why I can't just write the text in B9 in the function.

I tried the following formula, but it didn't work:
SUMIFS(D7:D999,G7:G999,"=INDIRECT('sheet2'!B9)"

Thanks!
Helpful
+0
plus moins
dshaviv, Good morning.

Try to use:

=SUMIF(G7:G999, sheet2!B9, D7:D999)

is that what you want?
I hope it helps.
--
Belo Horizonte, Brasil.
Marcílio Lobão
dshaviv 2Posts Sunday September 24, 2017Registration date September 25, 2017 Last seen - Sep 25, 2017 at 01:22 AM
Hey thanks for your comment.
I found that a simple SUMIFS function will do the trick.
Reply
Leave a comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!