Please Login or Register to view this content.
Please Login or Register to view this content.
Thread moved to the other platforms section as it is about Google Sheets functionality.
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.
Hi,
I think all you require is to wrap the whole thing in an ARRAYFORMULA function like this
=arrayformula(sum(countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,{"Return requested","Refund Done","Return Completed","Return Received","Partial Refund"})))
Don
Please remember to mark your thread 'Solved' when appropriate.
Hello Friend,
Thank you very much for your reply.
I had tried this formula but didn't work. It counted data for the status "Return Requested". (For the first string in the array)
Then I tried with this formula and has worked.
=countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Refund Done")+countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Return Completed")+countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Return Received")+countifs('Order-Customer data'!E:E,A3,'Order-Customer data'!D:D,"XL",'Order-Customer data'!H:H,"Partial Refund")
That is interesting- I have just tried the arrayformula version in Google sheets and it worked for me. Perhaps it is a regional settings issue.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks