Hi,
I am trying to calculate the number of nonblank cells in column C with respect to a specific condition in column A
for example in sheet 0 in column A the value should be " done" and in Column C the value can be some number
I used the below formula
=SUMPRODUCT((countif(sheet0!C2:C100,"<>")*(Sheet0!A2:A100 ="done")) this formula is not serving the purpose , please help.
May be this...
Formula:
Please Login or Register to view this content.
If your problem is solved, then please mark the thread as SOLVED>>Above your first post>>Thread Tools>>
Mark your thread as Solved
If the suggestion helps you, then Click *below to Add Reputation
Syntax for countifs is as follows
=COUNTIFS($F$1:$F$500, ">=" & X, $F$1:$F$500, "<" & X+365)
Elegant Simplicity............. Not Always
Hey bravo Sixth sense, thanks a lot.....even the last formula I used also u only gave...awesome u r
Glad it helps you and thanks for the feedback
I suppose there's not much difference between sum and count if you're not too fussy
Ok thanks for the info AndyLitch
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks