View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
RagDyeR RagDyeR is offline
external usenet poster
 
Posts: 3,572
Default HELP with a formula

What's in G12 to G1336?

Is it text data (alpha/numeric plate numbers), or what?

Better yet, describe what type of data is in each of your columns.

Tells us if we can use SumProduct, or do we need maybe Index&Match.
--

Regards,

RD
----------------------------------------------------------------------------
-------------------
Please keep all correspondence within the Group, so all may benefit !
----------------------------------------------------------------------------
-------------------

"Sudz" wrote in message
...

Thanks for all the help so far guys, its helped a little. This is the
actual formula im trying to fix

=SUMIF('Input Drivers State'!A12:I1336,AND('Input Drivers
State’!B12:B1336 = "PE96",'Input Drivers State'!I13:I1336 ='License
Numbers'!B37),'Input Drivers State'!G12:G1336)


--
Sudz
------------------------------------------------------------------------
Sudz's Profile:
http://www.excelforum.com/member.php...o&userid=36083
View this thread: http://www.excelforum.com/showthread...hreadid=558674