LinkBack URL
About LinkBacks
Aha, perhaps by non-blank you really mean 'non-blank' and not '>0' (which I took from your formula)
Try
=SUMPRODUCT((H8:H407<>"")*(C8:C407="SITE A"))
If this does not work, kindly upload a sample!
Aha, perhaps by non-blank you really mean 'non-blank' and not '>0' (which I took from your formula)
Try
=SUMPRODUCT((H8:H407<>"")*(C8:C407="SITE A"))
If this does not work, kindly upload a sample!
Life's a spreadsheet, Excel!
Say thanks, Click *
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks