ExcelA CountIF question... I think

goldenneko

Hi,
I am trying to use some of the more complex formulas, to make things easier on myself.

I have a workbook, with 4 sheets. The first 3 are data, and the 4th is a merging of the first 3. The teams will be making changes to Columns H, I, & J on the first 3 sheets. Right now, all 4 sheets have identical information.

So far, on sheet 4, I have added 2 additional columns for each corresponding column on the first 3. Column G collects from Sheet 1 G2, Column H from Sheet 2, G2 and Column I, G2 from Sheet 3. Same with J, K, L (from H2) Same with N,O,P (collecting from I2)

The ONLY reason it is like this, is in case the same exact item is counted in a second place. (I need to see if that happens.)

So - here is the question: I would like Sheet 4 Column M to tell me how many marks are in G2:L2, but because there are formulas in those cells, it counts the formulas. What do I do instead?

If you have ideas for making this easier, I'm all for ideas!

Thank you!

Becky

Webmistress
Welcome to the forum!

If I'm understanding you correctly, you could try using the COUNTA formula instead of COUNTIF. It counts the number of non-blank cells in a range, which might work well for you here.

Hope this helps!