Hello!
I attached an Excel file and the results that I want.
I tried in many ways, but I didn't find a way.
Would you like to help me?
Thank you.
Hello!
I attached an Excel file and the results that I want.
I tried in many ways, but I didn't find a way.
Would you like to help me?
Thank you.
Last edited by Zero-Sama; 06-17-2023 at 10:39 AM.
Turn A1 to AB2 into a structured table: select the range > Insert > Table.
EDIT: I've updated the formulae for you.
Last edited by AliGW; 06-16-2023 at 05:50 AM.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Are you confusing columns & rows??
Is this what you wanted:
=SUMPRODUCT(FILTER(H2:H400,A2:A400<>""),FILTER(C2:C400,A2:A400<>""))/SUM(FILTER(C2:C400,A2:A400<>""))
for min, similar for max
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.
Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh
Convert to table so ranges are dynamic (size adjusts automatically) & use structured references in formulas.
If it's been helpful please mark as helpful
Try, in H29 and dragged across:Formula:Please Login or Register to view this content.
H32 should auto adjust but, when use IFERROR:Formula:Please Login or Register to view this content.
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
Solved with AliGW's solution.
You got all rep.
Thanks.
Glad to have helped.
Thanks for the rep.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks