I need a formula that is a combination of a productsum and an if statement. Here is an example:
=SUMPRODUCT(($G$13:$G$74="Approved")*1)
but ONLY IF
B13:B74 = "A"
How do I write this?
I need a formula that is a combination of a productsum and an if statement. Here is an example:
=SUMPRODUCT(($G$13:$G$74="Approved")*1)
but ONLY IF
B13:B74 = "A"
How do I write this?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks