Excel Addition Question

[SCNB2015]

When I have WBT triggered in column C and there is an X in column E, I want the total of column D in each row WBT is triggered to appear in Cell B45.

Example: WBT is noted in C4, C5 and C8. There is an X in E4, E5 and E8. I need to add up D4, D5 and D8 and have that total placed in B45.

Does this make sense?

Please help.

Thanks!

 

[shg]

Welcome to the board.

=SUMIFS(D4:D8, C4:C8, "WBT", E4:E8, "X")

Adjust ranges to suit.

 

[SCNB2015]

This is how I entered..
=SUMIFS(D5:D6, C5:C6, "WBT", E5:E6, "X")
Doesn't seem to want to add my D cells.

WBT is noted in C4 and C5.
I have 26 in D4 and 21 in D5.
There is an X in E4 and E5.
I added this fomula in B45 but it is not bringing the total over.

 

[shg]

This is how I entered..
=SUMIFS(D5:D6, C5:C6, "WBT", E5:E6, "X")
Doesn't seem to want to add my D cells.

WBT is noted in C4 and C5.

Row 4 isn't included in your formula ...

 

[SCNB2015]

I apologize...I entered this...

=SUMIFS(D4:D5,C4:C5,"WBT",E4:E5,"X")

I got a #VALUE! in my B45

 

[shg]

Works for me:

[Table="width:, class:grid"][tr][td]Row\Col[/td][td]

C​

[/td][td]

D​

[/td][td]

E​

[/td][td]

F​

[/td][td]

G​

[/td][/tr][tr][td]

4​

[/td][td]

WBT​

[/td][td]

26​

[/td][td]

X​

[/td][td]

47​

[/td][td]

F4: =SUMIFS(D4:D5,C4:C5,"WBT",E4:E5,"X")​

[/td][/tr]
[tr][td]

5​

[/td][td]

WBT​

[/td][td]

21​

[/td][td]

X​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[tr][td]

6​

[/td][td]

​

[/td][td]

99​

[/td][td]

​

[/td][td]

​

[/td][td]

​

[/td][/tr]
[/table]

Are you SURE that's the EXACT formula you entered?

 

[SCNB2015]

what is F47 for?

 

[shg]

F4 contains the formula that you would put in B45 or wherever you like. 47 is the result of the formula.

 

[Joe4]

Id you are still having issues, please let us know EXACTLY what you have in the following cells:
C4,C5,D4,D5,E4,and E5.