Previous Topic Next Topic

SUM IFS function

Solved/Closed
dshaviv Posts 2 Registration date Sunday 24 September 2017 Status Member Last seen 25 September 2017 - 24 Sep 2017 à 01:21
dshaviv Posts 2 Registration date Sunday 24 September 2017 Status Member Last seen 25 September 2017 - 25 Sep 2017 à 01:22
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!
Related:

1 response

Réponse 1 / 1
Mazzaropi Posts 1983 Registration date Monday 16 August 2010 Status Contributor Last seen 24 May 2023 147
24 Sep 2017 à 10:51
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 Posts 2 Registration date Sunday 24 September 2017 Status Member Last seen 25 September 2017
25 Sep 2017 à 01:22
Hey thanks for your comment.
I found that a simple SUMIFS function will do the trick.

Similar discussions

How to calculate positions (1st,2nd,3rd...) in Excel
hardy -
TrowaD -

6 responses
Clear cell contents based on value of another cell range using VBA
Tbonekiller -
Tbonekiller -

6 responses
help me to add particular cells
mathewmunna -
mathew munna -

2 responses
How to calculate position (1st,2nd,3rd) in excel....?
abdulwajid -
TrowaD -

1 response
Looking For a Value in a Cell
Tom9o -
rizvisa1 -

3 responses