Have problem with returned values with index/match formulas. All explained in attached excel book.
Have problem with returned values with index/match formulas. All explained in attached excel book.
Last edited by Glenn Kennedy; 01-04-2023 at 05:33 AM.
use a simpler formula:
=SUMIFS('dec22'!C:C,'dec22'!B:B,sum!$D$2,'dec22'!A:A,sum!A4)
Glenn
None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU
Hi. Forum Rule 1 is very short. It states: "Title must briefly summarize your request."
A GOOD thread title is the sort of thing you would use as a search term on Google*. Your chosen title would produce a squillion useless hits. In future, please take a bit more time to think of a descriptive title that would be "Google-friendly". Many people search the forum answers looking for help and your very general title wouldn't help them at all.
Since you are a new or very infrequent user of this site, on this occasion, I have changed it for you.
However, if you continue to use weak titles, you can expect to have your thread BLOCKED until you change it yourself. If that happens, to edit the thread title, open the original post, click "Edit Post" (bottom right) to access the area where you can edit your title.
To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.
*Other search engines are available!!!
Regards,
Glenn.
The Product Group does not match the value in cell D2.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
If select column "A" & format as number with decimal place 2, some of client number not decimal
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Thank you very much. It works.
if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved" & Add Reputation button.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks