PLEASE HELP! Count data in multiple columns meeting certain criteria of another column

I'm lost, and not great with Excel. . .

I need to count how many cells have data in column 'J' and/or column 'L' if in column 'I' there is "DCC"

Thank you for any help, Rich

or maybe you can use iserror and vlookup
=IF(ISERROR(VLOOKUP("DCC",I:I,1,0)),0,COUNT(J:J))

if you have data in column L just add column L count
=IF(ISERROR(VLOOKUP("DCC",I:I,1,0)),0,COUNT(J:J)+COUNT(L:L))

I'm getting a number with that but not the right one. . .

Thanks again

It's getting close, I need to pop out, sorry. I wish I knew what you were posting copying and pasting doesn't work.

I'll try and explain more in a bit about what I'm looking for.

Thank you

ok. when you get back let us know.

how off is the count? maybe you have some cells in column J or L that we don't need to count? like a title maybe?
the formula works like this
=IF (look for text in column I, what happens if there is no dcc, what happens if there is dcc)

I think it should be OK, it's a table and I've acounted for that by replacing 'I:I' with the column heading.
I'm after 39 and I'm getting 35 and 44.

Column 'J' has blank cells or numbers, column 'L' the same. Column 'I' has text, either "DCC" or other text.

I need to know, when "DCC" is present, if there is a number in column 'J' or 'L' - sometimes there is a number in both - if that's the case, I only need to count it once

Hope that's kinda clearer, again, thank you for all the help!

I'm assuming that each row of J and L is in reference to the same row that I is on.
In that case, you may probably add another column, place a formula, and then sum the numbers in that column.

Formula:

Please Login or Register  to view this content.

Have I explained it clearly?

is it possible for you to attach your file so I could look?

Originally Posted by belle08

is it possible for you to attach your file so I could look?

https://www.dropbox.com/s/i4nl2xhsti0tyew/Anon.xlsx

you may also click on Go Advanced button lower right of the reply screen and go to Manage Attachments

i have the file already. let me see what i can do.

place this on cell P2

Formula:

Please Login or Register  to view this content.

you will have 39 counts

An alternative to SUMPRODUCT() would be:

=(COUNT([@[Helping Hands]],[@[Helping Hands Finished]])>0)*([@Funder]="DCC")