I have function like:
=SUMPRODUCT((MONTH('MyTab'!D3:D102)=1)*('MyTab'!U3:U102))
How to set IF function as empty or 0 value inside D3:D102 should not SUM any cells.
I have function like:
=SUMPRODUCT((MONTH('MyTab'!D3:D102)=1)*('MyTab'!U3:U102))
How to set IF function as empty or 0 value inside D3:D102 should not SUM any cells.
Hi toplisek, could you be a bit clearer as to what you want the IF to check for? Do you mean if SUMPRODUCT((MONTH('MyTab'!D3:D102)=1)*('MyTab'!U3:U102)) is equal to zero, don't sum?
May be something like this....
=SUMPRODUCT((MONTH(MyTab!D3:D102)=1)*(MyTab!D3:D102<>0)*(MyTab!U3:U102))
Something like 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
As i understand the question.
=IF(SUMPRODUCT((D3:D102="")*(D3:D102=0))>0,"",SUMPRODUCT((MONTH(D3:D102)=1)*(U3:U102)))
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.
It worsk. Thanks. What will do <>0
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks