Sumif with 2 ranges & 2 criteria
Prior to XL07, array formulae (which SUMPRODUCTs are, even though they
don't need to be entered with CTRL-SHIFT-ENTER) don't accept entire
columns as arguments.
You could use something like:
--($B$1:$B65535="Lot 27")
In article ,
cgibby wrote:
Ok I got that to work, thanks you!
i have another question though. I tried using
(--($B:$B="Lot 27"),(--($C:$C="Labor"),$D:$D) to add all of the columns,
but it didn't work. is there a reason why i can't do the "$"
|