Hi,
I need to sum an array conditioned to two criteria.
Example:
I need the sum of all bills that are still pending and expiring same day.
please see dummy file attached.
thank you very much.
Carlo
Hi,
I need to sum an array conditioned to two criteria.
Example:
I need the sum of all bills that are still pending and expiring same day.
please see dummy file attached.
thank you very much.
Carlo
Last edited by kghisla; 12-08-2010 at 06:37 PM.
Here, try this:
=SUMPRODUCT(--($D$3:$D$11="P"), --($C$3:$C$11=A19), $B$3:$B$11)
Never use Merged Cells in Excel
It works, thank you very much Zbor!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks