LinkBack URL
About LinkBacks
Dear Friends,
I am using the following formula
=IF((TEXT(O$11:O$376,"mmmm")=A11),COUNTA(P$11:P$376),0)
But it does not take the first part rather taking whole range P$11:P$376.
Kind regards,
Sunbhash
Dear Friends,
I am using the following formula
=IF((TEXT(O$11:O$376,"mmmm")=A11),COUNTA(P$11:P$376),0)
But it does not take the first part rather taking whole range P$11:P$376.
Kind regards,
Sunbhash
Could you please describe what you are trying to do? since the formula seems to be not perfect for conditional formatting purpose.
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
Try
=SUMPRODUCT((TEXT(O11:O376,"mmmm")=A11)*(P11:P376<>""))
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks