help!!!!

Status
Not open for further replies.

MATRI

New Member
Joined
Dec 13, 2005
Messages
3
:unsure: HOPEFULLY SOMEONE CAN HELP. its hard to explain what i need .so forgive my rambling
i have 2 work sheets (lets name them W1 and W2)
lets say in W1 i have 4 collums (something)(date)(color)(yadda)
i need a formula in W2 that can count how many (RED) on (1/1/2006)
if that makes any sence to anyone
 

Some videos you may like

Excel Facts

Easy bullets in Excel
If you have a numeric keypad, press Alt+7 on numeric keypad to type a bullet in Excel.
L

Legacy 51064

Guest
In W2:
=SUMPRODUCT((W1!B3:B10="1/1/2006")*(W1!C3:C10="RED"))
 

MATRI

New Member
Joined
Dec 13, 2005
Messages
3
THAT DIDNT WORK :( I WROTE
=SUMPRODUCT(('2006'!C3:300="1/1/2006")*('2006'!E3:E300="F/A")) which is what i actually needed but it dosent work
 

XLGibbs

Well-known Member
Joined
Feb 25, 2005
Messages
2,446
SUMPRODUCT(('2006'!C3:300="1/1/2006")*('2006'!E3:E300="F/A"))

should be

SUMPRODUCT(('2006'!C3:C300="1/1/2006")*('2006'!E3:E300="F/A"))

you were missing the second C if that is exactly what you typed in.
 
Status
Not open for further replies.

Watch MrExcel Video

Forum statistics

Threads
1,118,910
Messages
5,574,989
Members
412,633
Latest member
simon_elvin
Top