LinkBack URL
About LinkBacks
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?
Try this:
=SUMPRODUCT(--($G$13:$G$74="Approved"),--($B$13:$B$74 = "A") )
Never use Merged Cells in Excel
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks