Date amounts as reference from a range

Microsoft Excel 2007
September 12, 2009 at 11:35:48
Specs: Windows XP
hi

question:
how to read relevant items from a range, based on date?

description of my problem:
there is a colomn called "Payments" - it's also a range with same name.

i need to see, how many payments were made: this week, this months etc - what is the formula?

--------
i was trying to play with following formula, but it gives FALSE.
=IF((WeekNum) ...??? SUM(Payments))

thanks in advance,


See More: Date amounts as reference from a range

Report •


#1
September 12, 2009 at 11:42:23
I thought I solved it

=IF(WEEKNUM(TODAY())=(WeekNumber);(Payments))

but I didn't.
it takes only the first number in columns.

what to do?


Report •

#2
September 12, 2009 at 13:16:33
but then another question:

exiting ranges:
- client number
- client name

in another tab, I enter client number.
I would like it to retrieve the "client name", based on it's number from the range.

USING THIS, BUT IT DOESN'T WORK:
=IF(C6=(Client_Settings);(Marking_Settings))

c6 = cell with client number


Report •

#3
September 12, 2009 at 16:59:13
It sounds like your second question calls for VLOOKUP.

e.g. with your Client Numbers in TabName!A1:A5 and your Client Names in TabName!B1:B5, you would use:

=VLOOKUP(C6,TabName!$A$1:$B$5,2,0)

Read up on VLOOKUP in the Excel Help files to see how it works.

As far as your first question, I'm not sure what you are looking for.

In your first post you said:

i need to see, how many payments were made

"How many" - to me at least - sounds like you want to count how many payments were made.

However, in your second post, you said you tried:

=IF((WeekNum) ...??? SUM(Payments))

The use of SUM tells me you want to add something.

What is you are looking for - a count or a sum?


Report •

Related Solutions

#4
September 12, 2009 at 18:08:07
hi DerbyDad03

small step a side:

WHAT IS THE DIFFERENCE BETWEEN REFERENCE TO RANGE or TO TABLE NAME?


Report •

#5
September 12, 2009 at 18:34:20
Please post your question as a separate thread.

I don't like to change subject matter within a thread. It messes up the archives.


Report •

#6
September 13, 2009 at 00:41:23
ok.
I think I'm spending too much time on excel.
size of my excel leaves me no hope for the future - will concentrate of access.

will publish separately.

thanks.


Report •


Ask Question