Microsoft Office Forums SUM IF AND --> #value!

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-03-2009, 08:24 PM
Z060081 Z060081 is offline
Novice
SUM IF AND --> #value!
 
Join Date: Feb 2009
Posts: 1
Z060081 is on a distinguished road
Default SUM IF AND --> #value!

Hi,

Is there anyone out there having the same problem as what i'm facing.



Seem like microsoft excel cannot check for 2 condition range.

my code is

=SUM(IF(AND(A9:B18=10001, E7:V7="Monday", E9:V18,0))

which give me #value!.


I have tried keying in =SUM(IF(AND(A9=10001, E7:V7="Monday", E9:V18,0)) which work but it is not the right range that I want.

Please advises.

Thanks.
Reply With Quote
Reply

Thread Tools
Display Modes



All times are GMT -7. The time now is 04:41 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Search Engine Optimisation provided by DragonByte SEO v2.0.37 (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft