RANGE EXCEL copy cell that meets criteria in a range

C

confused

on a data sheet all data is imputed - sheet 1
I have a range of cells ie a7 to a2028 with dates in them
next range of cells b7 to b2028 has either the letter s or c in them
next range of cells c7 to c2028 has numbers in them

I want to have another sheet (sheet 2) that takes information from todays
date and either s or c in column b

ie if a1 to a2028 equals march 26,2008 and b1 to b2028 equals c then take
the value in column c that is in the same row as the criteria met above

I tried using the below formula but get 0 for a response

=IF(AND('Ser Data'!A7:A2120=TODAY(),'Ser Data'!B7:B2120="s"),'Ser
Data'!C7:C2120,0)

Please help
 
P

PCLIVE

If the values in column C are numeric values, and there will only be one
match, then you could use a SUMPRODUCT.
=SUMPRODUCT(--('Ser Data'!A7:A2028=TODAY()),--('Ser Data'!B7:B2028="s"),'Ser
Data'!C7:C2028)

or if there will be multiple matches and you want to sum the numeric values
in column that meet the criteria, then the above formula will work for that
as well.

Else, I would suspect a Pivot Table might be helpful.

HTH,
Paul
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

find a cell in a range and copy another cell 1
copy cell range in other sheet 1
Populate worksheet with data that meets date range criteria 3
Formula to count data in a column that falls between a range 3
Summing a range of cells with criteria 7
for each in a range 1
lookup needed to give value where the lookup value is a string within a cell. 2
Eliminate blanks while copy row and transpose 11

Top