Tocogroup
asked on
How do I perform COUNTIFS on a range of merged cells in Excel 2010
Hi,
Is it possible to perform a COUNTIFS operation on a range of cells which include merged cells. For example, if i want to tally occurrences using two conditions: one on a range of merged cells, and the other on a range of single cells.
I've attached an example of the worksheet with my COUNTIFS formulae which don't tally correctly.
Thanks
Toco
Tests-and-Summary.xlsx
Is it possible to perform a COUNTIFS operation on a range of cells which include merged cells. For example, if i want to tally occurrences using two conditions: one on a range of merged cells, and the other on a range of single cells.
I've attached an example of the worksheet with my COUNTIFS formulae which don't tally correctly.
Thanks
Toco
Tests-and-Summary.xlsx
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Much appreciated to you both