Hello, This is my first time here and I wanted to say Hi... I have a single spreadsheet that i want excel to count as a one if any number OTHER than blank or 0 is in a cell. The cells to check and look for these numbers are p19,x19,af19,an19,av19,bd19,and bl19 There happent o be 3 numbers in these cell a 1 3, and five. I want the results to be 3 as there are 3 days above 0.. this formula is saying 7.... I dont have a clue what is wrong any suggestions???
=SUMPRODUCT((COUNTIF(INDIRECT({"p19:p19","x19:x19","af19:af19","an19:an19","av19:av19","bd19:bd19","bl19:bl19"}),"<>")>0)+0)
Bookmarks