## Excel expert

I have a 2 rows in excel table.- 1st row is for Month and 2nd row is for score. The table is dynamic that a new month is added after every month. I need a …

I have a 2 rows in excel table.- 1st row is for Month and 2nd row is for score. The table is dynamic that a new month is added after every month. I need a …

Hello, I have two columns column E and column F. some cells have a X and some dont. I’ve tried using countif but it counts the rows that have …

Hello, I am trying to find an answer to this problem. I can see that there are answers to this on Google but I’m still finding it hard to …

Hi! I study use of Excel in my university, but I’ve encountered insurmountable challenge in my latest homework. No previous teaching material or …

I want the automated values in ROW 21 to show how much more or less revenue we made that weekday (weekdays in ROW 7). Total revenue a day in ROW 20. I …

I want the automated values in ROW 21 to show how much more or less revenue we made that weekday (weekdays in ROW 7). Total revenue a day in ROW 20. I …

I currently have this formula =sumproduct(––isnumber(match(Closers!A:A,‘Consent to Contract’!E:E,0))) This is counting all matching …

Hi, I need an excel formula if cell contains text then return TRUE/FALSE in another cell. For instance, if cell B2 contains the text “large” and …

Hi I need some help. I want to put in one column for example 5 times letter X (in two rows) X X X X X X X X X X and I want to have Sum of them (or count) to …

This is long shot but hope someone can help out. What im trying to achieve is a formula to calculate the average of a range of cells using the countif …

Hi, Please how to I count the number of yes in coloumn are the match dog or car in column b? By:

I am trying to create a table to track how many times a referee has refereed a certain player. In my table i have as follows: Basically i want to count the …

We use cookies to personalise content and ads, to provide social media features and to analyse our traffic. We also share information about your use of our site with our social media, advertising and analytics partners. How Google uses data when you use our partners' sites or apps

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.