LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 2
Default Need to sum row 7 columns based row 8 columns that are not Blank

I am trying to sum the columns in row 7 as long as the columns in row 8 are
not blank

Example:

a b c d e
f g h
7 2007 7 3 4 4 6 5 3
8 2008 67 82 76 131

I've tried this formula =SUM(INDEX(1/COUNTIF(B8:M8,B8:M8&"")*B7:M7,0))

however it is adding column 6 that should not be adding giving me a result
of 24 instead of 18.

Please can you help me on this matter. I need to add all columns in row 7 as
long as the respective column in row 8 is not blank.

Thanks,

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I allow blank columns in a .CSV file? RPG7906 Excel Discussion (Misc queries) 8 January 27th 08 09:17 PM
Delete blank columns. John Excel Discussion (Misc queries) 7 November 29th 07 10:48 PM
Delete rows with certain columns blank Slohcin Excel Discussion (Misc queries) 2 November 1st 06 02:35 PM
how can I blank out columns that are not being used rnooner Excel Worksheet Functions 4 August 24th 05 11:56 AM
Tallying columns based on values of 2 different columns Mctabish Excel Worksheet Functions 1 January 30th 05 10:40 AM


All times are GMT +1. The time now is 09:12 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"