If colmn D values = 'C', sum corresponding values from column B in one cell ??

**bridgitte** · 11-25-2015, 11:27 PM

Hi
Not sure if this is possible via formula -
If value in D6 is 'C', take vaule from B6 and sum in D3.
Then if value in D7 is also 'C'. take value from B7 and also sum in D3.
So wherever C exists in Column D, take corresponding values fromcolumn B and add all together in cell D3. Thanks!

excel formula.jpg

**Jonmo1** · 11-25-2015, 11:34 PM

Try

=SUMIF(D$6:D$20,"C",$B$6:$B$20)

**bridgitte** · 11-25-2015, 11:53 PM

Perfect thank you Jonmo1!

**Jonmo1** · 11-25-2015, 11:54 PM

You're welcome

If colmn D values = 'C', sum corresponding values from column B in one cell ??

LinkBack

Thread Tools

Rate This Thread

Display

If colmn D values = 'C', sum corresponding values from column B in one cell ??

Re: If colmn D values = 'C', sum corresponding values from column B in one cell ??

Re: If colmn D values = 'C', sum corresponding values from column B in one cell ??

Re: If colmn D values = 'C', sum corresponding values from column B in one cell ??

Thread Information

Users Browsing this Thread

Similar Threads

Transpose values in column to rows, and split cell values to extend column

[SOLVED] distinguishing between 3 values and returning another value based on cell values/column

Comma Separated Cell Values to Column of Unique Cell Values

[SOLVED] Replace values between two keywords in a colmn

Macro to find all specific values in column and replace adjacent cell values

Find and pluck out certain values on a column, then copy paste the adjacent cell values

[SOLVED] Macro to loop through cell values in a column and format multiple cell values

Bookmarks

Bookmarks

Posting Permissions