Have a Question?

If you have any question you can ask below or enter what you are looking for!



Eexel

hi,

Lee 25-Jul-03 10259 $100.80
Lee 29-Jul-03 10260 $1,504.65
Lee 30-Jul-03 10261 $448.00
Callahan 25-Jul-03 10262 $584.00
Dodsworth 31-Jul-03 10263 $1,873.80
Suyama 23-Aug-03 10264 $695.62
Fuller 12-Aug-03 10265 $1,176.00
Leverling 31-Jul-03 10266 $346.56
Lee 6-Aug-03 10267 $3,536.60
Callahan 2-Aug-03 10268 $1,101.20
Buchanan 9-Aug-03 10269 $642.20
Davolio 2-Aug-03 10270 $1,376.00
Suyama 30-Aug-03 10271 $48.00
Suyama 6-Aug-03 10272 $1,456.00
Leverling 12-Aug-03 10273 $2,037.28


i need sum criteria is below.

name(lee),month(7)



  Rakesh Sharma


try this


=SUMPRODUCT(AmountRange*(NameRange="Lee")*Month(DateRange=7))


SUMIFS cant work since criteria_range since criteria_range is not compatible with formula driven ranges..AFAIK


  Asheesh Mattoo       01 Aug 2016       0       0     

Correction

=SUMPRODUCT(AmountRange*(NameRange="Lee")*(Month(DateRange)=7))


  Asheesh Mattoo       01 Aug 2016       1       0     

Post Your Answers:

Please use the CODE HIGHLIGHT Button to format/highlight your codes if any