## How to sum a cell across several worksheets using indirect cell reference

QUESTION : Assume, I have Worksheets A-Z. I want to SUM cell, C21, across several worksheets (e.g. A-Z). I’ve tried […]

## SharePoint calculated column to check if the cells of the row have value, if any of the cells have value then take up that value

QUESTION : I need a calculated column formula for following condition: There are three columns “Column1”, “Column2” & “Column3” in […]

## How to add 4 hours in a format cells as yyyy-mm-dd hh:mm:ss and fit year,month and day

QUESTION : How to add 4 hours in a format cells as yyyy-mm-dd hh:mm:ss and fit year,month and day. Example […]

## Sum Index/Match based on criteria

QUESTION : I’m trying to lookup and sum values based on multiple criteria. In the attached image I have each […]

## Formula to establish specific dates 1 year apart

QUESTION : I’m working on a formula to align with our business’ invoicing policy. The rules are that, if an […]

## Excel: Return last positive value on row, and another value related to it

QUESTION : I have a sheet on which values relating to website URL redirect chains are returned. At the end […]

## Conditional Formatting in Excel selecting wrong rows when trying to highlight cells greater than 15

QUESTION : I am attempting to highlight cells that are greater than 15. But it’s highlighting all of the cells […]

## Compare response category from 2 columns in Excel and identify category change

QUESTION : I have 2 columns that have drop down menus with 5 options (character). orange apple banana broccoli spinach […]

## Countifs array with number of days

QUESTION : I’m looking to see how many days people are around between certain blocks. e.g. with people and the […]

## Cell to Equal Value of Different Cell based on Match in Array

QUESTION : Need to Column C to equal the text in Column G based on the match the value in […]