Excel A CountIF question... I think


Joined
Aug 31, 2018
Messages
2
Reaction score
1
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!
Excel Question.JPG
 
Ad

Advertisements

Becky

Webmistress
Joined
Mar 25, 2003
Messages
7,424
Reaction score
1,511
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!
 
Ad

Advertisements

Joined
Aug 31, 2018
Messages
2
Reaction score
1
Becky,
Thank you for the welcome! And thank you for the suggestion! The COUNTA worked in both the column I was referring to, but in a second one, as well. Thank you again!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If andf countif 1
CountIf with And 0
Excel Drag autofill only part of formula 3
Excel Countifs/Sumproduct with mutil Or statement 3
Excel Count If Formula Question 1
Help with countifs 1
Excel vba code to match duplicates 4
Excel Need Countifs Formula Help 0

Top