SUM IFS function

Solved/Closed

dshaviv Posts 2 Registration date Sunday September 24, 2017 Status Member Last seen September 25, 2017 - Updated on Sep 24, 2017 at 04:19 AM
dshaviv Posts 2 Registration date Sunday September 24, 2017 Status Member Last seen September 25, 2017 - Sep 25, 2017 at 01:22 AM

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!

Use the ifs function to return 5 if cell a5 contains the value 3, and return a 6 if it contains any other number.
Gta 5 download apk pc - Download - Action and adventure
Hitman 3 cheats - Guide
If cell contains date then return value ✓ - Excel Forum
Excel formula to check if cell contains a date - Excel Forum
Psiphon 3 download - Download - VPN

1 response

Answer 1 / 1

Mazzaropi Posts 1985 Registration date Monday August 16, 2010 Status Contributor Last seen May 24, 2023 147
Sep 24, 2017 at 10:51 AM

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 September 24, 2017 Status Member Last seen September 25, 2017
Sep 25, 2017 at 01:22 AM

Hey thanks for your comment.
I found that a simple SUMIFS function will do the trick.

Similar discussions

Excel function question

If cell = date return yes or no.

help me to add particular cells

If a cell contains any text then add a value

Excel: If Date =, then enter a value

Similar discussions

Subscribe To Our Newsletter!