=SUMIF Wildcard+Date

[liverebel]

I have three columns with in financial sheet. One is a check number, one is the date the check was written, and the last is the check amount. Assume Column A is ck# B is ck date and C is check amount. Why does this formula not work as it seems very simple.

=SUMIF(ColumnB,"04/*/15",ColumnC) Where I am trying to make it total only the checks written within April 2015.

[zbor]

Try this:

Please Login or Register  to view this content.

[liverebel]

More accurately my formula is

=SUMIF(Table1[Date of Check],"04/*/15",Table1[Check])

[liverebel]

Worked like a CHARM!!! Zbor you sir, are a gentleman and a scholar!!

It just seems weird that something that should calculate so simply has to be so.....over engineered.

[zbor]

Actually, it shouldn't be calculated that way because dates in excel are numbers.
What you see with / / is just formatting.
Therefore you can not use wildcards that way.

[liverebel]

once again an excellent explanation! Thanks!