Hi Masters,
This Formula Gives Error =Aggregate(9,6,{1,2,3,#N/A,4}), Actually I Want To Call An Array By Giving A Condtion To A Range "=Aggregate(9,6,(F22:F33="A")*(G22:G33))" In Aggregate Function To Get Sum Or Average. Is There Any Way By Aggregate Function.
please help me.
Sincerely
Ankur Shukla
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Check points 6 & 7.
http://www.exceluser.com/excel_help/...-aggregate.htm
Cheers!
Deep Dave
Dave, sorry I didn't get it. 6 & 7 point is talking about hidden rows but here problem is other. Let me clear you.
Column A having alphabets A,B,C D,A,A,#N/A and all and column B having values like 1,2,3,4,3,5,6 etc. Now I wanna sum conditional if column A having A alphabet then add the numbers thru aggregate function.
Is it possible thru this function or not??
Thanks
Ankur Shukla
Point 6 & 7 state that
I don't think it is possible.AGGREGATE returns a #VALUE! error when you use a Reference function, even if you arrray-enter the formula.
Though I may be very wrong.
Only functions 14-19 handle arrays. Functions 1-13 do not.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
Try
=SUMIF(A:A,"A",B:B)
you can try:
=SUM((F22:F33="A")*(G22:G33)) with control+shift+enter
or
=SUMPRODUCT((F22:F33="A")*(G22:G33))
My response in post #6 was based on the OP description in post #3 using just columns A and B
=SUMIF(A:A,"A",B:B)
This is what it should look like using the actual ranges OP used in original posted formula
=SUMIF(F22:F33,"A",G22:G33)
Thanks @Tony This is what I want to know,,,, Thanks All other solutions
You're welcome. Thanks for the feedback!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks