Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Fred Holmes
 
Posts: n/a
Default SUMIF with two conditions

Is there a way to use SUMIF or some similar function with two
conditions?

I have a credit card transaction listing downloaded from my bank.

I want to sum the purchases (amount is 0) only within a date range
(another column has the dates). It's easy to formulate the SUMIF with
either of the two conditions, but I don't see how to apply both.

Thanks,

Fred Holmes
  #3   Report Post  
Gary's Student
 
Posts: n/a
Default

use the AND() function within sumif
--
Gary's Student


"Fred Holmes" wrote:

Is there a way to use SUMIF or some similar function with two
conditions?

I have a credit card transaction listing downloaded from my bank.

I want to sum the purchases (amount is 0) only within a date range
(another column has the dates). It's easy to formulate the SUMIF with
either of the two conditions, but I don't see how to apply both.

Thanks,

Fred Holmes

  #4   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

No, that will not work

--
Regards,

Peo Sjoblom


"Gary's Student" wrote in message
...
use the AND() function within sumif
--
Gary's Student


"Fred Holmes" wrote:

Is there a way to use SUMIF or some similar function with two
conditions?

I have a credit card transaction listing downloaded from my bank.

I want to sum the purchases (amount is 0) only within a date range
(another column has the dates). It's easy to formulate the SUMIF with
either of the two conditions, but I don't see how to apply both.

Thanks,

Fred Holmes


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
sumif with two conditions ww Excel Worksheet Functions 3 March 31st 05 01:44 AM
SumIF w/ two conditions (not the same as other posts!... I think) MeatLightning Excel Discussion (Misc queries) 7 February 8th 05 10:55 PM
SUMIF with two conditions ? Mestrella31 Excel Discussion (Misc queries) 9 December 22nd 04 01:09 AM
Sum(if ... multiple conditions ... Interpretation? Ken Excel Discussion (Misc queries) 6 December 16th 04 11:23 PM
SUMIF based on 2 conditions TimH Excel Worksheet Functions 3 October 28th 04 08:18 PM


All times are GMT +1. The time now is 04:47 PM.

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

About Us

"It's about Microsoft Excel"