OK your profile says you're using XL2007 - if you can't see COUNTIFS I suspect you're actually running an earlier version.
Does the below work ?
=SUMPRODUCT(--(X2:X381=1.60);--(G2:G381="H"))
Going forward please attach files here directly.
OK your profile says you're using XL2007 - if you can't see COUNTIFS I suspect you're actually running an earlier version.
Does the below work ?
=SUMPRODUCT(--(X2:X381=1.60);--(G2:G381="H"))
Going forward please attach files here directly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks