i have columns A through columns F.
im trying to get a running count in one cell where column F value is greater than 0 and Column A value = "A". i can do this with helper columns but is there a more efficient way with a line of code?
thank you for your time
Last edited by kamelkid2; 07-24-2011 at 10:44 AM.
tRY
=SUMPRODUCT(--($A$1:A2="A"),--($F$1:$F2>0),$F$1:$F2)
thank you for your help. i was able to accomplish it using countifs function prior to reading post but i will test yours.
thank you for time
If you have Excel 2007/2010, COUNTIFS is a better solution than SUMPRODUCT here.Originally Posted by kamelkid2
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Reply With Quote
Bookmarks