Thread
:
SUMIF cells in Column B are blank
View Single Post
#
1
Posted to microsoft.public.excel.worksheet.functions
Josh Hendrickson
external usenet poster
Posts: 1
SUMIF cells in Column B are blank
I am trying to figure out how to sum numbers in column A but only if the
cells in the corresponding row in column B are blank. Any ideas?
I thought this would work but it hasn't so far
=SUMIF(B:B, ISBLANK(B:B), A:A)
Reply With Quote
Josh Hendrickson
View Public Profile
Find all posts by Josh Hendrickson