So you want count if and sum if based on Re-Sign?
You can use this.
=COUNTIF($B$2:$B$37,$B$2)
=SUMIF($B$2:$B$37,"Re-Sign",$C$2:$C$37)
And don't understand why Left/Right is required when you have Re-Sign as is? Am I missing something?![]()
So you want count if and sum if based on Re-Sign?
You can use this.
=COUNTIF($B$2:$B$37,$B$2)
=SUMIF($B$2:$B$37,"Re-Sign",$C$2:$C$37)
And don't understand why Left/Right is required when you have Re-Sign as is? Am I missing something?![]()
Cheers!
Deep Dave
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks