Tech Support Guy banner
Status
Not open for further replies.
1 - 1 of 1 Posts

·
Registered
Joined
·
8,565 Posts
If Excel 2007, use SUMIFS.

Otherwise, use something like:

=B3-SUMPRODUCT(($B$8:$B$12="PM")*($C$8:$C$12=$B$2))
 
1 - 1 of 1 Posts
Status
Not open for further replies.
Top