tech tips - Mati News

Mar132023 by abcNo Comments

Excel Tips: Formula to Sum up values of a column for a specific value of another column

Tech news

Suppose, there are two columns in Excel. The first column contains the name and the second column contains the payment. I want a formula to sum up all the payment values for the same name in the first column. Here is the Excel code for getting the summation for a specific name or value for another column. You can use the SUMIF function in Excel to sum all the payment values for the same name in the first column. Here are the steps: Select a cell where you want to display the sum. Type the following formula into the formula bar: =SUMIF(A:A, "Name", B:B) Replace "Name" with the name in the first column that you want to sum. Replace A:A with the column that contains the names. Replace B:B with the column that contains the payments. Press Enter. The formula will c...

Precautions on Using the Gimbal | How to use the gimbal

Tech news, প্রশ্ন ও উত্তর

Nowadays we do videos on mobiles. But for so long there was only one problem, when we tried to hold the mobile in hand to make some videos, it would show shaking. Technology has brought that solution. Here comes the gimbal. The gimbal is an electrical device. Which helps to hold your mobile or camera horizontally or vertically with the help of sensors. No matter how you or your hand move, the gimbal will keep your mobile upright. But there are some caveats to be followed while using this gimbal. DJI series gimbals are now popular among gimbals. Among them, DJI Osmo 4 and Osmo 5 are more popular. The price of the first in Bangladeshi taka is like 9000 taka (around $100) and the second is a little more. You have to be very careful when using this device. Becau...

How to make a Facebook page popular

Tech news

It takes a couple of minutes to open a Facebook page. After that, of course, not everyone will like or follow. I want to be patient to increase the likes on the page, I want to know some special tips. Set the name and URL of the page keeping in mind what people are searching for by typing on Google or Facebook. Keep page names or URLs as simple as possible. If the description, slogan, address, website, phone number, location of the page are not correctly filled or left empty, Facebook will not organically promote that page. So fill in this information over time. It's nice to be able to add your own animated or video cover. When uploading a picture, don't forget to write a nice description of it. Pin the most interesting post on the page. Put your Like and Comment on good posts on o...