Started By
Message

re: Excel Gurus, Converge!

Posted on 3/5/15 at 10:18 am to
Posted by jeekers78
Member since Sep 2005
433 posts
Posted on 3/5/15 at 10:18 am to
You can use SUMIF or SUMIFS with a wildcard * or ? as place holders. So somthing like:

=SUMIF(range, criteria [, sum_range])

=SUMIF(X1:X99,"z*",Y1:Y99)
Posted by LSUtigerME
Walker, LA
Member since Oct 2012
3850 posts
Posted on 3/5/15 at 12:10 pm to
SumIFs will work, but you'll have to convert the date range to Excel Date code. The wildcard won't work in that format difference.

If you have two other cells you can use to define the date range, it'll be easy. Cell A is lowest date, Cell B is higher date.

= SumIfs(Y1:Y99, X1:X99, ">="&Cell A, X1:X99, "<="&Cell B)

ETA: there's some assumptions, mainly that the dates are actual date format, and not text. If text, the wildcard will work and SumIf only required (assuming you only want to sum the month without multiple years and no other functionality required).
This post was edited on 3/5/15 at 12:21 pm
first pageprev pagePage 1 of 1Next pagelast page
refresh

Back to top
logoFollow TigerDroppings for LSU Football News
Follow us on Twitter, Facebook and Instagram to get the latest updates on LSU Football and Recruiting.

FacebookTwitterInstagram