Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 12th 05, 10:06 PM posted to microsoft.public.excel.worksheet.functions
mike camburn
 
Posts: n/a
Default Summing values if conditions are true

Hello, I am fairly new to advanced excel functions. I have a question that
may require multiple steps. I will describe my issue as simply as I can.

In cell E1, I need to SUM the values in column D if columns A, B, & C all
meet specific criteria.

For Example: IF A3=2006, B3=3, & C3=1, THEN D3 should be added to E1.
If any one of the three criteria is not true then D3 should not get added to
E1.

Thanks to everyone who contributes to this site. It has been very helpful.
-Mike


  #3   Report Post  
Old December 12th 05, 10:38 PM posted to microsoft.public.excel.worksheet.functions
Ragdyer
 
Posts: n/a
Default Summing values if conditions are true

To simplify your criteria choices, how about entering them at the top of
their respective columns instead of "hard-coding" them in the formula.
This makes changing them easier then having to revise the formula itself,
plus it helps with equalizing the data formats, since I'll assume that
"2006" is a date.

Try something like this:

=SUMPRODUCT((TEXT(A3:A100,"yyyy")=TEXT(A1,"yyyy")) *(B3:B100=B1)*(C3:C100=C1)*D3100)

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"mike camburn" <mike wrote in message
...
Hello, I am fairly new to advanced excel functions. I have a question that
may require multiple steps. I will describe my issue as simply as I can.

In cell E1, I need to SUM the values in column D if columns A, B, & C all
meet specific criteria.

For Example: IF A3=2006, B3=3, & C3=1, THEN D3 should be added to E1.
If any one of the three criteria is not true then D3 should not get added
to
E1.

Thanks to everyone who contributes to this site. It has been very helpful.
-Mike




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
Count if 2 conditions are true Thrava Excel Worksheet Functions 2 July 21st 05 01:56 AM
Summing Values In Current Month Only qflyer Excel Worksheet Functions 3 June 27th 05 06:29 AM
LOOKING FOR A NAME, THEN SUMMING ALL VALUES ASSOCIATED WITH NAME Peggy Excel Discussion (Misc queries) 4 June 22nd 05 06:48 PM
Multiple If True Values? Lee Excel Discussion (Misc queries) 8 February 9th 05 12:45 PM
Summing Values from different workbooks Harlan Grove Excel Discussion (Misc queries) 0 November 26th 04 08:38 PM


All times are GMT +1. The time now is 05:08 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017