Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Why is this SUMIF not working?

A formula using SUMIF doesn't seem to be giving the expected answer. A screenshot is attached. What it's meant to do is to sum items in column I when there's no date in column M. It works in rows 78 & 80, but not in row 79.

It would be good if one could put a formula like NOT(ISBLANK()) into the criterion, but this doesn't seem to be possible.

image description