Sumproduct with conditions - urgent help needed
Try this:
=SUMPRODUCT(--(F8:F13="XYZ"),I8:I13,N8:N13)
--
Biff
Microsoft Excel MVP
"JANA" wrote in message
...
I have a sumproduct in my spreadsheet =sumproduct(N8:N13,I8:I13) that works
fine. However, I need to add a condition to this. If F8:F13="XYZ". How
do
I change the sumproduct to only calculate if column F contains "XYZ"?
Your help would be greatly appreciated - under a tight deadline for a
client!
Jana
|