Got this function from Excel Help but it gives me #Value error. Can anyone help?
=SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
Number of invoices for Buchanan with a value less than 9,000. (1)
Got this function from Excel Help but it gives me #Value error. Can anyone help?
=SUM(IF(A2:A7="Buchanan",IF(B2:B7<9000,1,0)))
Number of invoices for Buchanan with a value less than 9,000. (1)
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks