Click here to Skip to main content
15,743,609 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I am using AGGREGATE Functions in MS Excel 2007, i got this error #NAME?

using this function DATE Column, i tried
SUBTOTAL instead of AGGREGATE. but not worked.

What I have tried:

i used this Function 

<pre>=IF($G55 <> "",AGGREGATE(14,4,($G$2:$G$51=$G55)*$F$2:$F$51,1), "")
Updated 21-Apr-23 1:51am
CHill60 21-Apr-23 9:53am    
You will get far better solutions if you include sample data and the results that you are expecting from that data - or at least explain what it is you are trying to do.

1 solution

Here is how the Aggregate function works: The Aggregate Function in Excel 2010+ - YouTube[^]
Share this answer
2011999 21-Apr-23 7:57am    
Excel 2010 is Working but Excel 2007 not Working. how do work with Excel 2007
Graeme_Grant 21-Apr-23 8:05am    
Ah, as the video explains, Aggregate was added to 2010 version. Official support for Excel 2013 ended this week: End of support for Office 2013 - Microsoft Support[^].

A quick check and the Subtotal function is the closest however works slightly differently. DO a quick search on Youtube and there are many videos explaining how it works. You might be able to use it instead.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900