SUMIFS to include only blank field for one of the criteria

[tadaas]

I am looking to utilize the SUMIFS formula for my time tracking spreadsheet. I have one criteria to sum values that are equal to a certain value "V" for vacation, and "D" for Dr Appointment. I am not trying to include the criteria that sums those values if they haven't been submitted, so I can keep track of future values.

I've looked through other posts, and saw responses... but they don't work for me.


Here's a mock formula:

=SUMSF(Type Range, Type, Hrs, Submitted Date, Blank)

=SUMIFS(B$51:B$62,E2,C$51:C$62,D51:D52, ?)

Any help would be greatly appreciated

 

[AlanY]

ok, thanks for the feedback