Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default Conditional Sum based on independent evaluation

I am trying to figure out how to sum certain cells in a row that correspond
to a Date in the same column. For example.
A B C D E
F G
1 DATE 1/1/2008 2/1/2008 3/1/2008 4/1/2008 5/1/2008
2 VENDOR 3/1/2008 10 20 30 40 50

In this example. I want to sum all the numbers in row 2 which have a date
greater then or equal to the date in cell b2.
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 915
Default Conditional Sum based on independent evaluation

analysis headache wrote:
I am trying to figure out how to sum certain cells in a row that correspond
to a Date in the same column. For example.
A B C D E
F G
1 DATE 1/1/2008 2/1/2008 3/1/2008 4/1/2008 5/1/2008
2 VENDOR 3/1/2008 10 20 30 40 50

In this example. I want to sum all the numbers in row 2 which have a date
greater then or equal to the date in cell b2.


Not sure how your data is laid out exactly, but if it looks like this:

A B C D E F G H
1 DATE 01/01 02/01 03/01 04/01 05/01
2 VENDOR 03/01 10 20 30 40 50 120

H2 is =SUMIF(C1:G1,"="&B2,C2:G2)
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
Vlookup evaluation Mick[_2_] Excel Worksheet Functions 2 February 25th 08 02:22 PM
Evaluation Sheet perplexed Excel Worksheet Functions 2 March 10th 06 10:51 PM
Blank cell after evaluation JC Excel Discussion (Misc queries) 2 September 15th 05 08:01 PM
dealer evaluation AB Excel Worksheet Functions 1 June 15th 05 02:17 PM
Options Evaluation Michael G. Excel Worksheet Functions 0 January 28th 05 05:41 PM


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