LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
 
Posts: n/a
Default How to sum in an easy way?

I have the following sheet:

A | B | C
10 | 20 | 30
x | x | -

I would like to sum the second row (the one with values) for each
column that has the value "x" in the third row. In the example above
the sum should be 30 (10+20). How can I do that easily?

I have many columns after column C so I can't use a regular
IF-function.

Very grateful for fast response!

Regards,

S

 
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
Easy question? Page numbers ATC Excel Discussion (Misc queries) 1 February 1st 06 04:27 AM
How do I make each row add up seperatly? Please make it easy... Homeade baker and candy maker New Users to Excel 1 October 23rd 05 09:52 PM
OsCommerce - Easy Populate Script - CSV/TXT Conversion Problem. PriceTrim Excel Discussion (Misc queries) 3 July 5th 05 05:27 PM
new user with easy question? not easy for me speakeztruth New Users to Excel 5 June 3rd 05 09:40 PM
An easy macro question and one I believe to be a little more diffi TroutKing Excel Worksheet Functions 3 January 18th 05 09:17 PM


All times are GMT +1. The time now is 03:15 PM.

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"