Hi all,
I have a real simple (and possibly dumb) question. Why doesn't my sumproduct return the expected value?
Here's my formula (in G83):
=SUMPRODUCT(--(E83="AD")*(D83+G12),--(E83="dscvry")*(D83+F83),--(E83="CD")*(D83+G13),--(E83="AD-B")*(D83+H13),--(E83="receipt")*(D83+F83),--(E83="CD-B")*(D83+H13),--(E83="SCD")*(D83+G13))
Here's what my table looks like:
Ref / ! / Item / Days / Label / Contingent Date / Projected Date / Completed Date
H4 / 1 / Table Delivery / 5 / receipt / 12-5-2016 / [formula] 12-10-2016 / ---- [manual entry later]
The cells I'm adding together are dates and numbers of days to come up with a new date. What I'm trying to do is have SUMPRODUCT check the "LABEL" of the row it's in (83 in this example) and return a corresponding formula. So, if E83 has "receipt", sumproduct would return the sum of "D83+F83" (5 + 12/5/2016) and zero from the rest. The label field could also contain CD, AD, SCD, etc. Each one of these "labels" has it's own formula.
The problem is, the result of my formula is 0. Sumproduct isn't multiplying them, is it? My understanding is it's 0+0+0+0+0+0+23446+0+0, and not 0*0*0*0*0*57423*0*0. By the way, I don't need to use sumproduct, but this seems like a simple task and I'm stuck.
Bookmarks