| Home |
| Search |
| Today's Posts |
|
#9
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sum If in VBA - It's Urgent "SOS" Please...
-- Baapi "Baapi" wrote: Dim Cr1 As Range, Cr2 As Range, Cr3 As Range Dim RngP1 As Range, RngP2 As Range, RngP3 As Range eRowP = Worksheets("Production Log").Cells(Rows.Count, 1).End(xlUp).Row Set RngP1 = Range(Cells(5, 8), Cells(eRowP, 8)) Set RngP2 = Range(Cells(5, 10), Cells(eRowP, 10)) Set RngP3 = Range(Cells(5, 11), Cells(eRowP, 11)) Set Cr1 = Range("C11") Set Cr2 = Range("E9") Set Cr3 = Range("E8") Cells(R, C).Value = Evaluate("SUMPRODUCT(--(RngP1 = Cr1),--(RngP2 = Cr2),--(RngP3 = Cr3))") gives me #NAME? Now, I'm sitting on this for the past two days... Can someone please help resolve this NOW!!! -- Baapi ------------------------------------------------------------------------ Baapi's Profile: http://www.excelforum.com/member.php...o&userid=27333 View this thread: http://www.excelforum.com/showthread...hreadid=470376 |
Threaded Mode
