L
lavachickie
I'm a fairly light Excel user, which is why this is escaping me.
I'm reporting on some data kept on one sheet. The first task was
simple: out of a column, count the occurences of a certain value,
based on a list of values already on the reporting page. That one's
simple:
=COUNTIF('Credit Cards'!S:S,Counts!A3)
But how do I do this if what I want is to ONLY count cells within a
certain date range? Can you have multiple arguements, or is there
another way to do this?
Let's say I wanted to get THAT number, but only for dates between
1/1/07 and 1/30/07?
Thanks. I've searched high and low and don't get it. =)
I'm reporting on some data kept on one sheet. The first task was
simple: out of a column, count the occurences of a certain value,
based on a list of values already on the reporting page. That one's
simple:
=COUNTIF('Credit Cards'!S:S,Counts!A3)
But how do I do this if what I want is to ONLY count cells within a
certain date range? Can you have multiple arguements, or is there
another way to do this?
Let's say I wanted to get THAT number, but only for dates between
1/1/07 and 1/30/07?
Thanks. I've searched high and low and don't get it. =)