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 |
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 |
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 |
All times are GMT +1. The time now is 02:01 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com