All, Let me start of by saying thanks for the help.
I want to write what I thought was a simple formula.
If column A has text "XXXX" then look in range F9:M384 and count or sum the number of times you see text "XXXX"
I've tried several different formulas but the closest I've gotten is returning a #value! which I thought was just a formatting issue.
Here are some example formulas I've written but can't get to work... any suggestions?
=SUMIF('Dashboard'!A9:M384,('Dashboard'!A:A="P1"),('Dashboard'!F9:M384="Software")) This formula fails
=COUNTIFS('Dashboard'!$F9:$M384,"Controls",'Dashboard'!A9:A384, "=""P1") This returns a #Value!
Any ideas?
Maybe an IF Then statement??
Thanks again for your time.
Matt
Bookmarks