Hi,
I have a data as per attached file.
I need to sum as per name of person with SUM and Index function.
function returns #VALUE!
Please guide how to fix the issue.
Thank You
kdraghu
Hi,
I have a data as per attached file.
I need to sum as per name of person with SUM and Index function.
function returns #VALUE!
Please guide how to fix the issue.
Thank You
kdraghu
try using
Formula:Please Login or Register to view this content.
if you want sum index then
Formula:Please Login or Register to view this content.
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST
More we learn about excel, more it shows us, how less we know about it.
for chemistry
https://www.youtube.com/c/chemistrybyshivaansh
Hemesh,
Your function is working.
But can you guide what was wrong with my SUm and Index function
you did not provided the row number to index function
another way to do the same is go to formula>>name manager>>create from selection check the left column
now click name manager and you will see excel has created names with values
then use formula asFormula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks