Hello,
Looking help to create a formula for the below:
If cells M13:M251 Says ‘Antonio’ and cells P13:1251 says ‘No’ then add up the figures in I13:I251
Thank you....
Hello,
Looking help to create a formula for the below:
If cells M13:M251 Says ‘Antonio’ and cells P13:1251 says ‘No’ then add up the figures in I13:I251
Thank you....
Use a pivot table to analyse the data.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
I just need a formula - maybe a countifs or sumsif of some sort?
Fast answers need visual help. Please read the yellow banner at the top of this page on how to attach a file.
Administrative note
Please update your profile as necessary to properly reflect the exact version(s) of Excel your question relates to. Members tailor answers based on your Excel version. Your profile does not indicate your XL version. It indicates your operating system version which is of no help to us.
Thanks
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks