I'm hoping someone can assist me with a formula (sample workbook attached). I have data that is spit out via a query in this format. I cannot edit the titles of the data. I am looking to return the number based off 4 different criteria. Two of them are in columns A and C, and the other two are in rows 3 and 4.
Is this possible?
posted by mistake
-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
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
copy paste below then hold control shift and enter to make it array
Formula:
Please Login or Register to view this content.
This worked, thank you!
Thanks for the feedback and I am glad I could help !
G29=SUMPRODUCT((A5:A22=D28)*($C$5:$C$22=E28)*(D2:O2=F28)*(D3:O3=G28)*(D5:O22))
don't use wrap text
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks