Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 7
Default adding specifics columns and rows

How do I add if I have in column B2 23, B3 34, B5 20, B7 16, and in column
C4 14, C6 30 if I put in column A2 a, A3 a, A4 c, A5 b, A6 c, A7 b. Total
sum in column B for all rows that are a only, total in column B for all rows
that are b only total sum in column C for all rows that are c only. Can it be
done in excel?
Thank u again

  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 3,718
Default adding specifics columns and rows

check your answer in your previous post.


"yodochi" wrote:

How do I add if I have in column B2 23, B3 34, B5 20, B7 16, and in column
C4 14, C6 30 if I put in column A2 a, A3 a, A4 c, A5 b, A6 c, A7 b. Total
sum in column B for all rows that are a only, total in column B for all rows
that are b only total sum in column C for all rows that are c only. Can it be
done in excel?
Thank u again

Reply
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
adding more columns/rows Jo Davis Excel Discussion (Misc queries) 4 September 24th 08 07:57 PM
How do I print certain (specifics) columns in Excel spread sheet? MariVi Excel Worksheet Functions 3 July 9th 07 09:59 PM
Hyperlinks doing weird things when adding columns or rows hssmith Excel Worksheet Functions 0 December 30th 05 04:21 PM
Disable Adding & Deleting Rows/Columns Playa Excel Discussion (Misc queries) 1 February 3rd 05 03:42 PM
Disable Adding or Deleting Rows and Columns Playa Excel Discussion (Misc queries) 1 January 10th 05 10:23 PM


All times are GMT +1. The time now is 01:03 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"